Re. Re. Quality of Index

> > 2) run "select * from syssqexplain order by sqx_estcost desc" from the > sysmaster database. This will display your current queries in the engine > by cost. By studying that, you will be easily able to see where your > costs are being incurred. DO NOT RUN THIS ON ANY ENGINE PRIOR TO > 7.13!!!!!!!!! > > Strictly speaking this is not correct! What this will show you is what the optimiser thought the cost was going to be BEFORE it executed the query, not what actually happened. And we all believe the optimiser knows best don't we ;-} Seriously, I have had (and still have) real problems trying to figure out eg. which is the better of two queries, whether a query will run faster with or without a certain index, etc. All help, advice, etc., gratefully received. Incidentally Madison, what happens to your query on the syssqexplain view if you do run it on a pre-7.13 engine? Peter Whittleton (whittle@ssax.com)