Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    1

    Unanswered: Subquery taking huge time to execute

    Hi,

    I am using a correlated subquery with the Outer query table and the subquery table being the same. The problem is that it is taking a huge time to execute. I have checked the showplan and it shows that the outer query is using one index and the inner query is using another index......

    Can this be a reason for the slow performance ... will it be better if both the subquery and the outer query utilise the same index.

    Can some please throw some light on this.......

    Thanks

  2. #2
    Join Date
    Jun 2003
    Posts
    140
    try to use use self join instead of sub qurery or post u r query here

Posting Permissions

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