if table A has a primary key
and table B has a field with a foreign key on A.primary
does that field in table B also need an index or will it use the index for the
primary key?
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
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.
SL That approach is not true is 100% of cases. It depends on many factors:
- How
Hi Roland,
I have tried to change this parameter (actually =20), but I don't see any
change.
20? It is below all meaningful values.
If you are using SuperServer, set 1, if Classic or SuperClassic, set
1024, and _restart_ Firebird.
What else can I test?
If you are interested in