Re: Update Stats after Create Index?

Hi Mark, Yes my question was really do I need to run update stats so that the optimizer will recognize the indices. So you are saying I don't need to do that. Wow great! That saves me another few hours of processing. Yes I understand that if the data changes after the indexes are built then I do need to run update statistics. In this scenario, periodically, I will actually be rebuilding drop/create the table and loading in historical data. --Dave On Fri, Oct 2, 2009 at 11:40 AM, Mark Jamison <majp51@yahoo.com> wrote: > Hi Dave, > > The answer is really predicated on what you mean by your question. > > If what you are asking is: > > "Do I still have to run update stats in order for my indices to be > recognized by the optimizer" > > Then the answer is no. Create Index commands do that for you automatically > now. > > If you are asking whether you need to manual run update stats on the table > periodically (which you probably are not) then the answer is yes that is > recommended, however you can accomplish that by taking advantage of the > automated update statistics facility in 11.50 > > -Mark > > > ------------------------------ > *From:* Dave <in4mixdba@gmail.com> > *To:* informix-list@iiug.org > *Sent:* Friday, October 2, 2009 9:34:02 AM > *Subject:* Update Stats after Create Index? > > Hello, > > I am on informix 11.50.FC4. If I have a new table loaded with 80 > Million records and create 5 indexes. Do I still need to run update > statistics? > > --Dave > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >