Hi

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

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)