|Subject||Re: [ib-support] Plan not working|
> I have CREATE INDEX CUSTOMER_NAME_KEY ON CUSTOMER (NAME, INITIALS);Is this exactly the command use are using ? It should use index.
> 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)