> 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