Re: Questions conerning the Optimizer

In article <34EA1CEF.86D@harrahs.com>, Carlos Bolden <cbolden@harrahs.com> writes >I have a couple of questions: > >I was looking at the sqexplain table ( in sysmaster ) and was wondering, >how does the cost based optimizer use these values to determine the >optimization method to be used? > >( I was trying to guess upon what methods were being taken, but my >guesses were starting to not starting to make sense. Database is >Informix ODS 7.14UC patched ) > >Now this question is not very important, but I would like to know if >there is a way to tell 'SET EXPLAIN' to dump it's information out to a >filename other than 'sqexplain.out'? > No >In a stored procedure? > > >Thaks, ( : - 7 ) > >Carlos -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care