somebody can to tell me as optimizer my querys , that is to say as i use the update statistics and way to create indexes
thank Nestor Luis ----- Original Message ----- From: "Edson Carlos Ericksson Richter" <[EMAIL PROTECTED]> To: "Nestor Rojas" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, May 31, 2003 9:59 AM Subject: Re: set explain > To "explain" a query, just issue > > explain select * from MyTable where MyField = '123' > > (just putting explain word ahead will give path used by optimizer) > > Best regards, > > Edson Richter > > > ----- Original Message ----- > From: "Nestor Rojas" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Saturday, May 31, 2003 11:34 AM > Subject: set explain > > > > > > hello list friends > > i want know as it is implemented set explain (informix) in sapdb to make > pursuit to a query > > thanks > > Nestor > > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.486 / Virus Database: 284 - Release Date: 29/5/2003 > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
