Re: Where v. If in high hit rate tables

> paul sellars <paul@boothbc.demon.co.uk> writes: > The following was suggested to one of my colleagues: > Using I4GL to get rows from a large table with a high hit rate, there > is a performance advantage in moving the selection criteria from the > where clause to an if statement inside the loop. All the responces you got explained what to do. Just for your information the above was often very true some years back, particularly with Informix SE. The performance advantage even when the hit rate wasn't very high gould be tremendous. I think that was to a large extent due to the optimiser not selecting the best access path, but may also have had several other reasons. This is generaly no longer the case. Nils.Myklebust@ccmail.telemax.no NM-data, Aasesvei 71, 1300 Sandvika, Norway My opinions are those of my company