Q: Optimising joins with views in SE, versions 7.12 to 7.23

I am about to upgrade and am in the middle of writing a rather complex query involving views. Does anyone know whether the optimiser has been improved to reduce its tendency to create temporary tables when queries involve a join with a view? If not, is there anything else I can do to persuade queries to use the available index paths? I do a weekly UPDATE STATISTICS LOW but this does not do much in SE. Bearing in mind that all the joins are indexed, what might be the optimal level of distribution statistics to use? The data distributions do not change quickly as the rate of data addition is about 20% increase per year. I understand that the best solution to this question is obtainable only by experiment - I'm just after a few clues to reduce the range of experiment required. Thanks for your help. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 --- If all else fails, read the instructions. All opinions are my own and not those of Bayer plc. My Internet plumbing does not allow me to mail and post news together. Sorry. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/