Viewing 2 posts - 1 through 2 (of 2 total)
Thanks for reply....
the main difference i have seen in these are
Left Join: i need to prepare the query as table (Temporary Table) and actual join will be provided after filtering...
August 18, 2013 at 10:43 pm
#1642535
Change ID to Cluster Index so that index data will be sorted in order and query output will be faster.
August 16, 2013 at 4:37 am
#1642070