Simple SELECT’s--continued
Use efficient WHERE clauses
Apply criteria to indexed columns
Use operators that utilize indices—BETWEEN may perform better than >= X and <= Y (know your engine!)
Don’t apply criteria in CFIF if can do in DB
Previous slide
Next slide
Back to first slide
View graphic version