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...

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>...