Re: Hints for table

Posted in 2000

Isidre PONS ROCA — Fri, 23 Jun 2000 08:42:10 +0200 — source: Informix-list mailing list archive (1991-1998)

En Xpietje va escriure el dia 22 Jun 2000, a les 15:48: > Hey All, > > Now we are working on Informix 7.24, we are going to make a upgrade to 7.31 > or 2000. > > In our application we are going to use "hints" (pointing the SQL in the best > tabel/index direction), 7.24 doesn't support this! > > Does anybody know if 7.31 or 2000 support this (Oracle and SQLserver do)? > > Thanks, > > Alex > > Informix 7.31.XXX and IDS.2000/IIF.2000 suport special OPTIMIZER Directives to point indexes, joins metodes etc. Whits this directives you can force to the optimizer to use an index, etc. --------------------------------------- Isidre PONS ROCA BASE - Gesti' d'Ingressos Locals (Diputacio de Tarragona) Servei de Sistemes de Informacio Av President Lluis Companys 12-C 43005 - Tarragona SPAIN Tel # +34 977 236731 Fax # +34 977 227302 http://www.altanet.org ipons@dtgna.altanet.org ---------------------------------------