DelphiFAQ Home Search:
General :: Databases :: InterBase
Help with InterBase, Borland's open source database.

Articles:

This list is sorted by recent document popularity (not total page views).
New documents will first appear at the bottom.

Featured Article

Using indexes with InterBase

The types of indexes and the best choice depends on the DBMS. The following has been found for InterBase.

1) create indexes on columns that are used in where or join clauses of your SQL statements

2) if you use ORDER BY constructs, have an (compound) index of fields in the same order as in the ORDER BY construct

3) if you combine conditions with OR, you may want to have single indexes on each field of your conditions

select * from t where col1 =

Generated 16:00:32 on Oct 16, 2017