Re: select without indexes?

In article <363936b8.95108298@news.primenet.com>, justabill <justabill@school.house.rocks> writes >I am doing a two table join and I want to know if there is a way I can >get informix 7.23 not to use the indexes. The reason is because I >know that the join will return close to 100% of the rows so I want to >see if the dynamix hash join might be faster than using the index. Is >there any way to tell informix not to use the index? Drop the indexs? Set OPTCOMPIND=2 in ONCONFIG? -- 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