J
James Palmer
Guest
Query tuning is a massive area that it would be hard to do justice with in a forum like this. In terms of your example above, there is no benefit to the temp table, unless you were doing multiple queries on Customer within your code. You can cache the customer in a temp-table and so you're only reading it from disk in future calls. Caching of relatively static data in temp tables can be a major performance win if the data is read multiple times, or if you don't have sufficient indexes as you can define additional indexes on the tt.
Continue reading...
Continue reading...