Re: Hints for table

Posted in 2000

Obnoxio The Clown — Thu, 22 Jun 2000 20:00:34 BST — source: Informix-list mailing list archive (1991-1998)

From: "Xpietje" <Xpietje@Xpietje.com> > >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)? Yes. It's called Optimizer Directives, and it's all in the manuals, which can be downloaded from http://www.informix.com/answers/ :-) ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com