J
jmartin104
Guest
Let me try to explain with an example: for each customer: for each order of customer: /* do something */ end. How do we know the number of server hits it would take to complete to return the query results? Why would you choose (if ever) to loop through customer first and create a temp table and then use that temp table to loop through the order table? Note: in one sample case, customer would have less than 100 records while order could have thousands. My big question is would it matter if the customer records are better gathered into a temp table first.
Continue reading...
Continue reading...