I have a table with an integer column as the primary index. I want to make it DESC sorting order. I don't see a way to change this using the db manager. I created a secondary index against the same column with DESC sorting order, when I have the " order by ... DESC" in sql, the query is very slow, it seems the secondary index is not used. Thanks, Paul

Xiannong Chen or Paul

Could you please post the SQL statement and the table structure
(fields/indexes) and someone in NG can help you

Eduardo

Here is the SQL script to generate the column:
EXECUTE IMMEDIATE 'CREATE TABLE "bib"
(
"Ref_ID" INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1),
"Authors" VARCHAR(250) COLLATE "UNI",
...

Here is the SQL script to generate the constraint:
EXECUTE IMMEDIATE 'ALTER TABLE "bib"
ADD CONSTRAINT "PrimaryKey" PRIMARY KEY ("Ref_ID")';

Thanks,
Paul

Xiannong


ElevateDB currently creates unidirectional indices.

What you need is to add a descending  index

CREATE INDEX "Downwards" ON "bib" ("RefID" DESC)

In EDBManager go to the table and in the left hand pane double click it, click Indexes and then select Create New Index in the Tasks panel.

You can then add an index or you can use the SQL above.


Roy Lambert [Team Elevate]

Roy, Thank you. I remember with DBISAM, I can change the direction of primary index from ASC to DESC. It seems that is not possible in ElevateDB. Your suggestion works. Thanks, Paul