update statistics high/medium and performance

I found when I execute update statistics high for the index columns, the performance is better than medium,but the execute plan is the same, do anybody know the same SQL executed more quickly when using high mode for update statistics?

One possible reason is that running the HIGH has to read every key which would cause the engine to put inefficient indexes onto the BTREE Cleaner's hit list causing the cleaner to compress the index. Art On Wed, Dec 10, 2008 at 7:26 PM, CHUAN LU <luchuan@cn.ibm.com> wrote: > I found when I execute update statistics high for the index columns, the > performance is better than medium,but the execute plan is the same, do > anybody > know the same SQL executed more quickly when using high mode for update > statistics? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.