Help! View Optimisation

>> Chris Russell <chrisr@acatst01.cos.titan.com> writes... >> >> I am on a project that is using Informix. We have many tables, some >> [STUFF DELETED]... >> We are using Views quite extensively. [STUFF DELETED]... >> I am trying to find out how we can optimize these views. [STUFF DELETED]... >> Comments or suggestions? [STUFF DELETED]... Hello Chris, Your problem is a common one, i.e. how to get the best out of your sql code (optimisation) it is covered in the FAQ but, in short, look at the select part of your create view statement and run it with SET EXPLAIN ON. You should also try stepwise refinement (now where did I hear that before ?), select over fewer tables and build the related entities in, checking the output of set explain on at each step. You may well need to review INDEXING strategy on the tables involved. A good tip is to call UPDATE STATISTICS ( at least for the tables involved). Hope this helps Tom Hogarty Standard Disclaimers Apply SNI Paderborn Germany Tel +49-52518-11602 +49-5254-65553($HOME) e-mail <hogarty.pad@sni.de>