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? Thanks, -Jeff __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
