Creating Indexes

Hi. DBA Gurus,

   I have a select stmt,

select ....
from table1_at_ERP_ABC
where table1.fields1 = 'XYZ'
and table1.field2 = 'STU'
and table1.field3 != 'AAAA';

The query is very slow. And i found that there is no index on the composite column (field1, field2, field3). But there are other indexes on (field1, field2) & another one on (field3). If i create a index on (field1, field2, field3), will the query run faster?

Regards Received on Wed Nov 17 1999 - 10:31:41 CST