Re: select without indexes?

Posted in 1998

Gursoy YERLI — Fri, 30 Oct 1998 12:52:45 -0600 — source: Informix-list mailing list archive (1991-1998)

If you use PDQ (parallel database query), by setting PDQPRIORITY to values greater than 1, Informix uses (generally) hash join. By the way, what is that strange e-mail address. Gursoy YERLI justabill wrote: > > 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?