Posted by lsllcm on 11/27/07 01:58

Hi Gert-Jan,

Is there a join in the query? I get the feeling you did not post all
relevant parts of the query. Why would you get a merge join? And what
does "The system choose index prefix" mean?

There is no join in the query, I think the merge join is to merge the
results of different OR.

The system choose run the partial index of beginning "SERV_PROV_CODE".

Thanks
Jacky

• Next in forum: Re: Finding the user who do update in Query Analyser?
• Prev in forum: Re: many "or" operation make system choose incorrect index
• Thread view: Re: many "or" operation make system choose incorrect index

[Reply to this message]