I have a select query which is taking 1.5 sec of execute time.
select T93.C1,C8 FROM aradmin.t93 where ('SW BELL DS3 NNI - SPRINGFIELD' = T93.C536870923) ORDER
BY 1 ASC;
When I see the execution plan there is a full index scan .There is a non unique index on the column in the where cluase.
Can anyone give suggestion on how to decrease the execution time.
The platform is SunOS on Sparc,Oracle version is 8.0.5