Indexes that could be scanned from left to right or right to left..............

Hi ,
Are there any INDEXES in SQL such that they could be scanned from left
to right or right to left(like that in DB2).
Thanks,
Dutt.
Dutt
No , I'm afraid NO. What is the benefit to scan indexes from left to right?
What is your concern?
"Dutt" <Mr.Dutt@.gmail.com> wrote in message
news:1171015544.016561.150790@.h3g2000cwc.googlegro ups.com...
> Hi ,
> Are there any INDEXES in SQL such that they could be scanned from left
> to right or right to left(like that in DB2).
> Thanks,
> Dutt.
>
|||Hi Uri,
I'm converting some DB2 objects into SQL.
Tell me how to proceed with the following stmts.
CREATE INDEX "DB2ADMIN"."IDX604031811150000" ON "GPT
"."PRODUCT_FEATURE"
("FEATURE_CODE" ASC,
"END_DATE" ASC,
"START_DATE" ASC,
"PRODUCT_TIER_LEVEL" ASC,
"PRODUCT_CODE" ASC) ALLOW REVERSE SCANS;
Thanks,
Dutt.
|||Dutt
CREATE TABLE t1 (a int, b int)
GO
CREATE UNIQUE CLUSTERED INDEX Idx1 ON t1(a ASC,b DESC)
GO
Modify a,b columns to your and specify SORT
"Dutt" <Mr.Dutt@.gmail.com> wrote in message
news:1171017130.483643.192230@.s48g2000cws.googlegr oups.com...
> Hi Uri,
> I'm converting some DB2 objects into SQL.
> Tell me how to proceed with the following stmts.
>
> CREATE INDEX "DB2ADMIN"."IDX604031811150000" ON "GPT
> "."PRODUCT_FEATURE"
> ("FEATURE_CODE" ASC,
> "END_DATE" ASC,
> "START_DATE" ASC,
> "PRODUCT_TIER_LEVEL" ASC,
> "PRODUCT_CODE" ASC) ALLOW REVERSE SCANS;
> Thanks,
> Dutt.
>
>
|||Tibor,
In ur previous post I mistook that u r more concerned abt the order of
a single fielded index.
OK,I got u now.
Thanks,
Dutt.