Timeline for Which of these queries is best for performance?
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 1, 2013 at 19:07 | comment | added | RubberChickenLeader | The first has the more concise query plan. however with only 10 rows any tests would be affected by waiting for time on the CPU throwing off the results. I normally test on production sized data or 1 million rows (which ever is larger) where differences can clearly be seen (and a 10 - 15 ms delay in the start of execution does not completely skew the results). | |
| Nov 1, 2013 at 17:04 | comment | added | Kilise | ive provided the statics info in my post, check it out and tell me which query seems to be best for performance? | |
| Nov 1, 2013 at 16:58 | history | answered | RubberChickenLeader | CC BY-SA 3.0 |