Results 1 to 5 of 5

Thread: table scan

  1. #1
    Join Date
    Jun 2006

    Unanswered: table scan

    What could be the reason for a SQL query doing table scan while running but if we see the execution plan , it shows using indexes.
    i captured the query from statspack output and ran report with execution plan, it shows the table scan but if i just run the plan without going through statspack , it shows using index.
    any insight/expereince will be greatly appreciated.

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    When you post:
    * Give your post a meaningful title, so that people have some idea what it will be about. Titles like "Please help!" and "Newbie query" aren't very useful.
    * Posts should contain OS name & version
    * Posts should contain Oracle software version number to 4 decimal places
    * Posts should contain cut & paste copies of actual inputs & output messages
    * Use vb Code tags to make your post more readable. The most important of these is the code tag, which makes both code and examples clearer by using a proportional font and maintaining spacing - e.g. instead of this:

    Please follow the direstions in the #1 Sticky post which you did not read/follow.

    * Posts should contain cut & paste copies of actual inputs & output messages

    We (TINW) can not look over your shoulder to see what you are seeing.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Mar 2002
    Reading, UK
    Did you replace the bind variables with literals? This can often change the execution plan especially if you collected histogram stats.


  4. #4
    Join Date
    Jul 2003
    statistics accurate and up to date?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  5. #5
    Join Date
    Jun 2006
    yes statistics are accurate.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts