RE: Odd behavior with IDS11 optimizer .....Is ....

Posted in 2010

Everett — Thu, 02 Sep 2010 14:35:13 — source: IIUG Forums & Mailing Lists

> -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > jpierrot@chubb.com > Sent: Thursday, September 02, 2010 9:25 AM > To: ids@iiug.org > Subject: Re: Odd behavior with IDS11 optimizer .....Is .... [21126] > > Here is a sample output! > > (See attached file: Update Stats.log) The relay strips attachments. You'll have to include your log in the body of your post. --EEM > > = > > From: "Art Kagel" <art.kagel@gmail.com> = > > = > > To: ids@iiug.org = > > = > > Date: 09/02/2010 10:10 AM = > > = > > Subject: Re: Odd behavior with IDS11 optimizer .....Is .... [2112= > 2] > > = > > Sent by: ids-bounces@iiug.org = > > = > > What level of statistics are you using on these tables? > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > IIUG Board of Directors (art@iiug.org) > > Disclaimer: Please keep in mind that my own opinions are my own > opinion= > s > and > do not reflect on my employer, Advanced DataTools, the IIUG, nor any > ot= > her > organization with which I am associated either explicitly, implicitly, > = > or > by > inference. Neither do those opinions reflect those of other > individuals= > > affiliated with any entity with which I am affiliated nor those of the > entities themselves. > > On Thu, Sep 2, 2010 at 9:36 AM, jpierrot@chubb.com > <jpierrot@chubb.com>wrote: > > > I dropped the distributions again last night and run update > statistic= > s =3D > > and > > the query still hangs. Are there any variables out there that can > for= > ce=3D > > the > > optimizer to behave like in 7.31. > > > > Thanks! > > > > jp > > > > =3D > > > > From: "Obnoxio The Clown" <obnoxio@serendipita.com> =3D > > > > =3D > > > > To: ids@iiug.org =3D > > > > =3D > > > > Date: 09/01/2010 06:31 PM =3D > > > > =3D > > > > Subject: Re: Odd behavior with IDS11 optimizer .....Is .... [2111=3D > > 1] > > > > =3D > > > > Sent by: ids-bounces@iiug.org =3D > > > > =3D > > > > jpierrot@chubb.com wrote: > > > The problem seems to be with the second piece of the query or the > u= > ni=3D > > on=3D3D > > > > It seems like 11.50 is doing a sequential scan of the employee > table,= > > > rather than traversing an index. You absolutely sure the statistics > a= > re=3D > > > > kosher? > > > > -- > > Cheers, > > Obnoxio The Clown > > > > http://obotheclown.blogspot.com > > I will now proceed to pleasure myself with this fish. > > > > -- > > This message has been scanned for viruses and > > dangerous content by OpenProtect(http://www.openprotect.com), and is > > believed to be clean. > > > > > *********************************************************************= > **=3D > > ******** > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > =3D > > > > > > > > > *********************************************************************** > = > ******** > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --0050450175faf1dbe6048f475e82 > > *********************************************************************** > = > ******** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > = > > > *********************************************************************** > ******** > Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Everett

jpierrot@chubb.com — Thu, 02 Sep 2010 14:49:45 — source: IIUG Forums & Mailing Lists

K! = From: "Everett Mills" <Everett.Mills@nationalbeef.com> = = To: ids@iiug.org = = Date: 09/02/2010 10:35 AM = = Subject: RE: Odd behavior with IDS11 optimizer .....Is .... [2112= 9] = Sent by: ids-bounces@iiug.org = = > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of= > jpierrot@chubb.com > Sent: Thursday, September 02, 2010 9:25 AM > To: ids@iiug.org > Subject: Re: Odd behavior with IDS11 optimizer .....Is .... [21126] > > Here is a sample output! > > (See attached file: Update Stats.log) The relay strips attachments. You'll have to include your log in the bo= dy of your post. --EEM > > =3D > > From: "Art Kagel" <art.kagel@gmail.com> =3D > > =3D > > To: ids@iiug.org =3D > > =3D > > Date: 09/02/2010 10:10 AM =3D > > =3D > > Subject: Re: Odd behavior with IDS11 optimizer .....Is .... [2112=3D > 2] > > =3D > > Sent by: ids-bounces@iiug.org =3D > > =3D > > What level of statistics are you using on these tables? > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > IIUG Board of Directors (art@iiug.org) > > Disclaimer: Please keep in mind that my own opinions are my own > opinion=3D > s > and > do not reflect on my employer, Advanced DataTools, the IIUG, nor any > ot=3D > her > organization with which I am associated either explicitly, implicitly= , > =3D > or > by > inference. Neither do those opinions reflect those of other > individuals=3D > > affiliated with any entity with which I am affiliated nor those of th= e > entities themselves. > > On Thu, Sep 2, 2010 at 9:36 AM, jpierrot@chubb.com > <jpierrot@chubb.com>wrote: > > > I dropped the distributions again last night and run update > statistic=3D > s =3D3D > > and > > the query still hangs. Are there any variables out there that can > for=3D > ce=3D3D > > the > > optimizer to behave like in 7.31. > > > > Thanks! > > > > jp > > > > =3D3D > > > > From: "Obnoxio The Clown" <obnoxio@serendipita.com> =3D3D > > > > =3D3D > > > > To: ids@iiug.org =3D3D > > > > =3D3D > > > > Date: 09/01/2010 06:31 PM =3D3D > > > > =3D3D > > > > Subject: Re: Odd behavior with IDS11 optimizer .....Is .... [2111=3D= 3D > > 1] > > > > =3D3D > > > > Sent by: ids-bounces@iiug.org =3D3D > > > > =3D3D > > > > jpierrot@chubb.com wrote: > > > The problem seems to be with the second piece of the query or the= > u=3D > ni=3D3D > > on=3D3D3D > > > > It seems like 11.50 is doing a sequential scan of the employee > table,=3D > > > rather than traversing an index. You absolutely sure the statistics= > a=3D > re=3D3D > > > > kosher? > > > > -- > > Cheers, > > Obnoxio The Clown > > > > http://obotheclown.blogspot.com > > I will now proceed to pleasure myself with this fish. > > > > -- > > This message has been scanned for viruses and > > dangerous content by OpenProtect(http://www.openprotect.com), and i= s > > believed to be clean. > > > > > *********************************************************************= =3D > **=3D3D > > ******** > > > > Forum Note: Use "Reply" to post a response in the discussion forum.= > > > > =3D3D > > > > > > > > > *********************************************************************= ** > =3D > ******** > > > Forum Note: Use "Reply" to post a response in the discussion forum.= > > > > > > --0050450175faf1dbe6048f475e82 > > *********************************************************************= ** > =3D > ******** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > =3D > > > *********************************************************************= ** > ******** > Forum Note: Use "Reply" to post a response in the discussion forum. ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =