| Stupid
Query Tricks |
|
|
|
|
|
|
|
|
|
|
| • | Use a UNION to re-write a slow OR query |
||||||||
| SELECT
* FROM mytable |
|||||||||
| WHERE
col1 = ‘foo’ OR col2 = ‘bar’ |
|||||||||
| (SELECT
* FROM mytable |
|||||||||
| WHERE
col1 = ‘foo’) |
|||||||||
| UNION |
|||||||||
| (SELECT
* FROM mytable |
|||||||||
| WHERE
col2 = ‘bar’) |
|||||||||
| Copyright 2003, Jeremy Zawodny |