J. Jeff Roberts wrote: > I have queries like this that differ only by the direction of > the ORDER > BY clause: > > select field1 from table where field2 = x order by field3 > select field1 from table where field2 = x order by field3 DESC > > Using "explain", I can see that if I have an index on field3 > ascending, > it only gets used by the first query. If I have one index for each > direction, then I see the expected index being used in the explain > output. > > Is there any way to create one index that can be searched both > ascending and descending?
Motivated by a posting on this list we are implementing the usage of an index or primary key in reverse order. But the target release for this feature is 7.5 so for the actual releases there is no other way then create both indexes. Best regards, Holger SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
