Re: Creating Indexes

The query will not run faster while you have inequality on the last column. It will not use the index, as the index on field1,field2 is already sufficient.

Hth,

--
Sybrand Bakker, Oracle DBA
Praveen Mohanan <praveen_mohanan_at_hotmail.com> wrote in message news:942856189.920138_at_sj-nntpcache-1.cisco.com...
> 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 - 16:07:16 CST