Subject | How does interbase work with default indexes an prepared queries? |
---|---|
Author | delphi4everybody <DELPHI4ALL@HOTMAIL.COM> |
Post date | 2003-01-02T00:09:54Z |
Hi,
After working in SqlServer and Oracle,
Some concepts are mixed in my mind.
In Interbase when i especify a PRIMARY Key,Is an index created
Automatically?
And what about the unique clause,does it create an index too.
Does Interbase keeps the plans for the most used Queryes.
In Oracle preparing a query is not so relevant as it seems to
be in Interbase.
Regards,
Marcello Dias
After working in SqlServer and Oracle,
Some concepts are mixed in my mind.
In Interbase when i especify a PRIMARY Key,Is an index created
Automatically?
And what about the unique clause,does it create an index too.
Does Interbase keeps the plans for the most used Queryes.
In Oracle preparing a query is not so relevant as it seems to
be in Interbase.
Regards,
Marcello Dias