Do all filter criteria have to be fulfilled so that the system logs an SQL statement?
No Comments Posted for this Article.
Tuning Expensive SQL Statements
What are typical approaches to tune expensive SQL statements?Depending on the results of the analysis of an SQL statement the following optimizations can be...
SQL InterfacetSelect Where vs. Select + Check tAlways specify your conditions in where clause rather than first selecting all the records and then using the check syntax.tSelect with index support...