General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Jay,
>
>Next you want to eliminate the HAVING clause as HAVING is always slower than WHERE, and what do you get ... the original query with the subselect in it.
As you say, what implementation you select depends on your goals at that moment. One provides probably better performance, the other gives more logical flexibility.
Jay
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only