Re: OPTCOMPIND explanation req'd

Posted in 1997

David Williams — Wed, 19 Mar 1997 23:34:59 +0000 — source: Informix-list mailing list archive (1991-1998)

In article <5gpauu$qem@cssun.mathcs.emory.edu>, Peter Whittletion <whittle@ssax.com> writes >Am I right in assuming that the OPTCOMPIND parameter is only >relevant to the performance of joins. This is what I thought >it was for, but the ODS 7.2 Performance Guide doc talks about >it in relation to single-table scans. > >Anyone tried it? > >Peter Whittleton (whittle@ssax.com) > It is A GENERAL HINT TO THE OPTIMIZER and affects weightings of indexes vs dynamic hash joins (table scans). This means ALL SQL statements are affected. -- David Williams