Saturday, February 22, 2014

does derive table use where clause fillters inside

Ideally query optimizer would have the intelligence to apply filter in the same way in both the occasions. You can run both the query with show execution plan option on and compare the execution plans to get a clear idea.


Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://ift.tt/19nLNVq http://ift.tt/1iEAj0c


No comments:

Post a Comment