Re: Problem with Index Advisor

[Luis Rodriguez <luis.rodriguez2@xxxxxxxxx>]

Elvis, Charles,

Thanks for your help. 

This (DDS-Defined) file has 22 indexes/LFs. And yes, Visual
Explain is using CQE ("TRANSLATION REQUIRED").

Regards,

Luis


--- midrange-l-request@xxxxxxxxxxxx wrote:
> message: 7
> date: Mon, 31 Mar 2008 15:35:44 -0500
> from: "Elvis Budimlic"
> <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>
> subject: RE: Problem with Index Advisor
>
> The "timeout" scenario should only occur with CQE, not
> SQE, so Luis ought to
> check which engine query is using in Visual Explain as
> well.
>
> Elvis
>
> Celebrating 11-Years of SQL Performance Excellence on IBM
> i5/OS and OS/400
> www.centerfieldtechnology.com
>  
>
> -----Original Message-----
> Subject: RE: Problem with Index Advisor
>
> I think can happen if you've got lots of indexes and the
> optimizer times out
> before it can look at all of them.
>
> How many indexes/Logical files exist for this table?
>
> Charles Wilt 
>
>
> ------------------------------


Luis Rodriguez

IBM Certified Systems Expert
eServer i5 iSeries Technical Solutions


      ____________________________________________________________________________________
You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost.  
http://tc.deals.yahoo.com/tc/blockbuster/text5.com