Multicolumn index - asc and desc for individual columns [CORE649]

[firebird-automations]

Submitted by: janrovner (janrovner)

Votes: 2

SFID: 957880#⁠ Submitted By: janrovner

I have not found any way how to create an index for multiple columns with different order for individual columns:

Firebird supports only

CREATE ASC INDEX indexname ON tablename (c1, c2, ...)

or this

CREATE DESC INDEX indexname ON tablename (c1, c2, ...)

What is *very* needed is this syntax:

CREATE INDEX indexname ON tablename (c1 [ASC|DESC], c1 [ASC|DESC], ...)

============================

I think this would be very easy to implement and in result *very* helpful.

[firebird-automations]

Commented by: Alice F. Bird (firebirds)

Date: 2006-01-24 13:03 Sender: adnanoncevarlik Logged In: YES user_id=1046258

Hi Dimitry,

We need this feature too.

Has it planned to make solution or any changings on indexing algorithm? Is there any information about this subject?

Thank you for your cooperations. Best Regards Adnan ?????NCEVARLIK

[firebird-automations]

Commented by: Alice F. Bird (firebirds)

Date: 2005-03-23 12:29 Sender: dimitr Logged In: YES user_id=61270

I fail to see how "easy" it would be to implement.

[firebird-automations]

Modified by: @pcisar

Workflow: jira \[ 10673 \] =\> Firebird \[ 15035 \]