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
Analyze Table and Index and then run explain plan.
Click Here to Expand Forum to Full Width