DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: high cpu time-full index scan

  1. #1
    Join Date
    Aug 2000
    Posts
    3
    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

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    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
  •  


Click Here to Expand Forum to Full Width