>Have tested and the difference is still enormous, some factor 10.
>As predicted the added between is slightly quicker than the union construction 
>and thanks for that tip. This is in 
>fact quite useful for me as currently I have to convert a OR SQL in code (VB) 
>to the UNION and as you can imagine 
>that can be quite tricky, particularly if there is an order by. So, I will 
>change this code now to add the between 
>instead and that will be a lot simpler.

It would be interesting to see the PLANs with the OR and UNION (and some 
information about the chosen indexes). I simply cannot remember anything like 
this with Fb 1.5.

Set

Reply via email to