yes - that is the exact command.

In fact any table I use where I would use an index is not being
chosen. Interbase always uses Plan Natural...

--- In ib-support@y..., "Ivan Prenosil" <prenosil@m...> wrote:
> > I have CREATE INDEX CUSTOMER_NAME_KEY ON CUSTOMER (NAME,
INITIALS);
> >
> > If I write the query select * from customer where customer
= 'SMITH'
> > order by name, initials
>
> Is this exactly the command use are using ? It should use index.
>
> >
> > I get the plan : PLAN SORT ((CUSTOMER NATURAL))
> >
> > How do i change this to my index ? Surely interbase should pick
up
> > the fact that I have an index on name, inititals (the index is
active)
>
>
> Ivan
> http://www.volny.cz/iprenosil/interbase