Viewing 2 posts - 1 through 2 (of 2 total)
Guys,
By replacing the union query with a temporary table you can get a further performance enhancement, this implies that a Constant scan is slower than a Table scan.
My results...
Beginning test...
May 29, 2007 at 4:03 pm
#709508
David's right, if you want to guarantee the data retrieved is sorted then you have to declare ORDER BY.
The ANSI standard quotes something like this..... 'If an <order by clause>...
May 29, 2007 at 3:57 pm
#709507