The Home of C&P Software on the Web

SQL Commands:

CREATE INDEX INSTANCE_NAME.ITEM_TABLE_IX1 ON INSTANCE_NAME.ITEM_TABLE
                (STORE_NUMBER ASC) ALLOW REVERSE SCANS;

RUNSTATS ON TABLE INSTANCE_NAME.ITEM_TABLE AND DETAILED INDEXES ALL;