-
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
saswati
junior dba
-
Analyze Table and Index and then run explain plan.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|