Help tuning a very poor SQL query

Help tuning a very poor SQL query

El Forum
Guest

#12

06-18-2009, 05:53 AM

[eluser]Dam1an[/eluser]
Wow thats a big difference!!!

When using a random number between 0 and row count, you need to take into account that row may not exist if you delete rows

Messages In This Thread

Help tuning a very poor SQL query - by El Forum - 06-17-2009, 08:03 AM

Help tuning a very poor SQL query - by El Forum - 06-17-2009, 08:19 AM

Help tuning a very poor SQL query - by El Forum - 06-17-2009, 08:24 AM

Help tuning a very poor SQL query - by El Forum - 06-17-2009, 09:42 AM

Help tuning a very poor SQL query - by El Forum - 06-17-2009, 09:47 AM

Help tuning a very poor SQL query - by El Forum - 06-17-2009, 10:10 AM

Help tuning a very poor SQL query - by El Forum - 06-17-2009, 10:28 AM

Help tuning a very poor SQL query - by El Forum - 06-17-2009, 11:21 AM

Help tuning a very poor SQL query - by El Forum - 06-17-2009, 11:40 AM

Help tuning a very poor SQL query - by El Forum - 06-17-2009, 11:49 AM

Help tuning a very poor SQL query - by El Forum - 06-18-2009, 05:49 AM

Help tuning a very poor SQL query - by El Forum - 06-18-2009, 05:53 AM

Help tuning a very poor SQL query - by El Forum - 06-18-2009, 06:02 AM

Help tuning a very poor SQL query - by El Forum - 06-18-2009, 09:57 AM

Help tuning a very poor SQL query - by El Forum - 06-18-2009, 10:14 AM