SQL Server Performance


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