Announcement

Announcement Module
Collapse
No announcement yet.

Problem with performance when using Stored Routines i.c.w. ORDER BY or Temp Table

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Problem with performance when using Stored Routines i.c.w. ORDER BY or Temp Table

    I already posted my question on Stackoverflow:
    http://stackoverflow.com/questions/1...ored-functions

    The problem appears when I try to use the results of the Stored functions in the ORDER BY. I also tried to store the result (without the ORDER BY) in to a temporary table, but ended up with the same result. The query runs fast if I remove the ORDER BY.

    Any directions are very welcome, thanks!
Working...
X