Subject | RE: [firebird-support] Composite Primary Keys and Indices |
---|---|
Author | Dimitry Sibiryakov |
Post date | 2004-07-23T05:03:32Z |
On 22 Jul 2004 at 6:10, Robert DiFalco wrote:
be created only after a good analyse of the slowest queries. Wrong
index can make things worse, as Helen already mentioned.
SY, Dimitry Sibiryakov.
>Cool. So would it follow that if I wanted to search on COLUMN_CHILD_IDIn common, searching does not require index. IMHO, indices should
>that I *should* create an Index for that column?
be created only after a good analyse of the slowest queries. Wrong
index can make things worse, as Helen already mentioned.
SY, Dimitry Sibiryakov.