Using indexes with InterBase

This article has not been rated yet. After reading, feel free to leave comments and rate it.

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 =

Comments:

Email address (not necessary): Rate as Off-topic Very Helpful Helpful Ok article Not useful Very bad	Hide my email when showing my comment. Please notify me once a day about new comments on this topic. Please provide a valid email address if you select this option.
It seems that you are from Washington, US . Info/ Feedback on this	Show city and country Show country only Hide my location
Leave your comment here:
Please type in the code:
Add a picture: Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity. The owner of this web site reserves the right to delete such material.