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