Post reply

After using RANK PARTITION, SP is taking too long to run

  • May 13, 2010 at 9:39 am

    #235043

    I have used RANK PARTITION() in my view. The SP which is using that view is taking way too long to execute. If I remove the RANK PARTITION part from the view, SP is working fine but I could not find a better alternate for RANK PARTITION(). Can someone suggest me something if you have any idea?

  • May 13, 2010 at 10:28 am

    #1167040

    You've provided basically zero information so all you're going to get are general guesses.

    My best guess is that the fields (in this example x and y) you are using on your RANK() OVER (PARTITION BY x ORDER BY y) are not properly indexed on the underlying table(s).

    └> bt


    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • May 13, 2010 at 11:41 am

    #1167094

    Hey thnx.. We r gonna do that... once again thnx for giving the idea..

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply