SQL Server Performance

optimization

Discussion in 'SQL Server 2005 Analysis Services' started by california6, Oct 11, 2007.

  1. california6 New Member

    Whats the difference between full vs light optimization? Also when i run full optimization, will it rebuild all the indexes on my OTP DB?
    Thanks for the input.
  2. thomas New Member

    Is this a maintenance plan you're talking about?

    I don't use them myself because I do not like them, but I believe full = reindexing and light = indexdefrag.
  3. satya Moderator

    Is the optimization for Analysis services databases or OLTP databases?
    Your question is confusion and cross-posted if its related to OLTP.

Share This Page