Not using an index

We're developing an application with hopes to be able to run it in both an Oracle and a Sybase environment. Does anybody know if this works in Sybase:

Select a.col_1, a.col_2, b.col_3, b.col_4 from table_1 a, table_2 b

where a.indexed_col_x ||'' = 'ABC'               <<<<--- This will cause
and   a.indexed_col_y = 'DEF'                            the query not to
and   a.indexed_col_z = 'GHI'                            use the index. 
and   a.col_1 = b.col_3

Thanks in advance

Adev Ahluwalia
QByte/Coopers and Lybrand
(403) 296 3334
adev_at_cuug.ab.ca Received on Fri Jun 09 1995 - 00:00:00 CEST