Sign in
Microsoft.com
 
Microsoft
 
 
 

none
Should I index columns that are used for filtered scope to improve performance RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi,

    I wonder if I should add indexes on the columns that are used for a filtered scope.

    Let's say on the server side I have a large table customer (about  1 million records) and I sync part of this with a filtered scope to the clients.

    I assume that before the sync, the table customer is (table-)scanned for records matching the filter clause, so this process is much faster when an index exists.

    Is this right, or does the provision process takes care of that?

    Or should trace the sync and then tune with DTA?

    Thanks
    Christian
    Friday, December 9, 2011 11:12 AM
    |

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    a sync framework application can be optimized in the same way that you optimize other database applications.

    apart from optimizing indexes (checking for defragmentation, reorganize/rebuild indexes, update statistics on base and metadata tables), make sure you do regular metadata cleanup as well.

    • Marked as answer by chl-h Wednesday, December 14, 2011 3:12 PM
    Saturday, December 10, 2011 10:56 AM
    |
    Moderator

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    a sync framework application can be optimized in the same way that you optimize other database applications.

    apart from optimizing indexes (checking for defragmentation, reorganize/rebuild indexes, update statistics on base and metadata tables), make sure you do regular metadata cleanup as well.

    • Marked as answer by chl-h Wednesday, December 14, 2011 3:12 PM
    Saturday, December 10, 2011 10:56 AM
    |
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    HI June,

    thanks for your answer.

    Can you recommend a link for reading more about metadata cleanup?

    Thanks

    Christian

    Wednesday, December 14, 2011 3:13 PM
    |
  • Question
    Sign in to vote
    0
    Sign in to vote

    not much other than in the docs: http://msdn.microsoft.com/en-us/library/ee617373.aspx

     

    Thursday, December 15, 2011 1:15 AM
    |
    Moderator