Subject Re: Index primer
Author Graham
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> At 10:25 AM 13/02/2008, Sean wrote:
> >Graham,
> >
> >> when they are created automatically?
> >
> >Indexes are created automatically for all PRIMARY and FOREIGN KEY
> >constraints.
>
> ...and UNIQUE constraints.
>
> ./hb
>

Thanks. So, in other situations I need to create my own indices.

Helen, does your book cover all of this ?

I need to optimize some queries which are terribly slow.