>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