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

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