|
|
|
Date Submitted:
08/04/05
Hits: 53 Rating:  based on 0 votes
Eliminate the Use of Temporary Tables For HUGE Performance GainsAdded by Papergrl
Description:
As queries become more complex, temporary tables are used more and more. While temporary table may sometimes be unavoidable, they can often be sidestepped by using derived tables instead. In brief, a derived table is the result of using another SELECT statement in the FROM clause of a SELECT statement. By using derived tables instead of temporary tables, we can boost our application's performance. Let's find out more.
Read the Complete Paper You don't have permission to post replies. Please login or register. |