Derby

the Derby site
 
   

Avoid expensive queries

Avoid expensive queries

Some queries can, and should, be avoided. Two examples:

SELECT DISTINCT nonIndexedCol FROM HugeTable
 
SELECT * FROM HugeTable ORDER BY nonIndexedColumn

See Prevent the user from issuing expensive queries.


Previous Page
Next Page
Table of Contents
Index