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

Thread: Help with indexes

  1. #1
    Join Date
    Jun 2001
    Posts
    316
    Hi,

    is there a possible way to find if select query fired is doing a table scan or an index scan?

    I have a table with xactlt 3 lac and 14 rows.....
    and a select query takes ages to to retrive result....
    though 5 cols have been indexed...
    any suggestions welcome
    thanx

  2. #2
    Join Date
    Jun 2001
    Posts
    316
    Just a reminder
    and is there a way to see the plan..as toike which objects oracle seeks during the search
    something like a table plan?

  3. #3
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    Look for some documentation on the EXPLAIN PLAN utility. A full explanation is too long for a post.

    This utility will help identify full table scans.

    One other point: it is possible to overindex.

    Good luck.
    David Knight
    OCP DBA 8i, 9i, 10g

  4. #4
    Join Date
    Apr 2001
    Location
    London
    Posts
    725

    Use the following :

    Use the following link to establish which code is problematic and what to do about it :

    http://www.dbspecialists.com/4dbas/p...e_explain.html

    Cheers

    Suresh

  5. #5
    Join Date
    May 2001
    Location
    New Zealand
    Posts
    123
    Hi

    Set autotrace on in Sqlplus and then
    Fire your select on sqlplus and you have the Stats in front of u .

    Hope that helps .........
    Cheers
    Afshin

  6. #6
    Join Date
    Jun 2001
    Posts
    316
    Thanx a lot!!!
    it was there in toad..a bit of search......
    thanx a lot again

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