Make use of Database Indexes

Indexes are vital for efficient data access and can improve the speed of SELECT statements.† In particular it is important to index any of your fields that you are making a join on.

However, exercise caution and work with your Database Administrator to build indexes, as they could slow the performance of INSERT, UPDATE & DELETE statements.

Please refer to the relevant query performance tuning documents within your DBMS vendorís documentation.

Spatial indexes should also be utilised for faster spatial queries.

Make use of Database Views