Showing posts with label value. Show all posts
Showing posts with label value. Show all posts

Friday, March 30, 2012

index statistics are created when?

If the auto create stats and auto update stats is off (actually the value is null) at the db level - are stats generated when an index is recreated?

Additionaly, running the sp_autostats on the above db shows that the auto update stats are on. Where is the option to set it on for an object rather than the db?

Mike

I just read by Kalen that if the options are false (off) this overrides the table level. Still not clear on what occurs when options are <null>True when you run DBCC DBREINDEX those stats will be updated too.

SP_AUTOSTATS is used to display or change the automatic UPDATE STATISTICS setting for a specific index and statistics, or for all indexes and statistics for a given table or indexed view in the current database.

Friday, February 24, 2012

index create memory

Hi,
I am trying to find out more information about the option "Index Create
Memory"..Will setting the "Index Create Memory" to a larger value other than
the default will improve the reindexing performance ? Do you guys know where
i can find good documentation on that ?
Thanks,SQL Server Books Online has information on this option
Dylan kruger
"kneel" <kvatsan@.comcast.net> wrote in message
news:OUIcabPaEHA.2520@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I am trying to find out more information about the option "Index Create
> Memory"..Will setting the "Index Create Memory" to a larger value other
> than
> the default will improve the reindexing performance ? Do you guys know
> where
> i can find good documentation on that ?
> Thanks,
>|||I checked it already and i thought it wasnt highly informative..
"Dylan kruger" <carmellobear1@.hotmail.com> wrote in message
news:%2314kbiaaEHA.3996@.TK2MSFTNGP12.phx.gbl...
> SQL Server Books Online has information on this option
> Dylan kruger
> "kneel" <kvatsan@.comcast.net> wrote in message
> news:OUIcabPaEHA.2520@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> > I am trying to find out more information about the option "Index
Create
> > Memory"..Will setting the "Index Create Memory" to a larger value other
> > than
> > the default will improve the reindexing performance ? Do you guys know
> > where
> > i can find good documentation on that ?
> >
> > Thanks,
> >
> >
>

index create memory

Hi,
I am trying to find out more information about the option "Index Create
Memory"..Will setting the "Index Create Memory" to a larger value other than
the default will improve the reindexing performance ? Do you guys know where
i can find good documentation on that ?
Thanks,
SQL Server Books Online has information on this option
Dylan kruger
"kneel" <kvatsan@.comcast.net> wrote in message
news:OUIcabPaEHA.2520@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I am trying to find out more information about the option "Index Create
> Memory"..Will setting the "Index Create Memory" to a larger value other
> than
> the default will improve the reindexing performance ? Do you guys know
> where
> i can find good documentation on that ?
> Thanks,
>
|||I checked it already and i thought it wasnt highly informative..
"Dylan kruger" <carmellobear1@.hotmail.com> wrote in message
news:%2314kbiaaEHA.3996@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> SQL Server Books Online has information on this option
> Dylan kruger
> "kneel" <kvatsan@.comcast.net> wrote in message
> news:OUIcabPaEHA.2520@.TK2MSFTNGP12.phx.gbl...
Create
>

index create memory

Hi,
I am trying to find out more information about the option "Index Create
Memory"..Will setting the "Index Create Memory" to a larger value other than
the default will improve the reindexing performance ? Do you guys know where
i can find good documentation on that ?
Thanks,SQL Server Books Online has information on this option
Dylan kruger
"kneel" <kvatsan@.comcast.net> wrote in message
news:OUIcabPaEHA.2520@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I am trying to find out more information about the option "Index Create
> Memory"..Will setting the "Index Create Memory" to a larger value other
> than
> the default will improve the reindexing performance ? Do you guys know
> where
> i can find good documentation on that ?
> Thanks,
>|||I checked it already and i thought it wasnt highly informative..
"Dylan kruger" <carmellobear1@.hotmail.com> wrote in message
news:%2314kbiaaEHA.3996@.TK2MSFTNGP12.phx.gbl...
> SQL Server Books Online has information on this option
> Dylan kruger
> "kneel" <kvatsan@.comcast.net> wrote in message
> news:OUIcabPaEHA.2520@.TK2MSFTNGP12.phx.gbl...
Create[vbcol=seagreen]
>