public marks

PUBLIC MARKS with tags performance & springnetdelicious

12 July 2006 12:15

Simon's Software Stuff: SQL Server performance tips

by springnet
Does your SQL statement have a WHERE clause? I know this sounds obvious, but don't retrieve more data than you need. However, less obvious is that even if your SELECT statement retrieves the same quantity of data without a WHERE clause, it may run faster

PUBLIC TAGS related to tag performance

join +   limit +   mysql +   rapidité +   sql +  

Active users

springnet
last mark : 12/07/2006 12:20