| Subject | Compound indexes |
|---|---|
| Author | |
| Post date | 2014-01-22T20:52:40Z |
I remember reading years ago that Firebird would compile multiple indexes based on the search requirement and that it was better to do indexes that way instead of creating multiple compound indexes.
eg
Table1 (
field1,
field2,
field3,
)
this is better
Create Index idx1 on Table1 (field1)
Create Index idx2 on Table1 (field2)
Create Index idx3 on Table1 (field3)
than doing it this way
Create Index idx1 on Table1 (field1)
Create Index idx2 on Table1 (field2)
Create Index idx3 on Table1 (field3)
Create Index idx4 on Table1 (field1, field2)
Create Index idx5 on Table1 (field1, field3)
Is that still correct in 2.5?