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

Thread: Oracle Execution Plan

Threaded View

  1. #1
    Join Date
    Feb 2004
    Location
    Chennai, India
    Posts
    7

    Oracle Execution Plan

    Hi,

    I am having same tables in two servers(S1 And S2). One is having approximately 1(S1) crore records and another one 3(S2) crore records when I am executing a query its using the index in S1 and its not using index instead of that its going for full table scan in S2 any idea why its happening like that. I attached the execution plan for the tables both are same only the rows are different.
    Any help is appreciated.

    Regds

    Krish
    Attached Files Attached Files

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