O'Reilly logo

Microsoft SQL Server 2008 High Availability by Hemantgiri S. Goswami

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 5: Merge Replication

Index on columns used in filters

It is important to create index on the columns that are used for filtering and joins so as to perform faster retrieval of data. Whenever merge agent runs, it searches for the data, if database engine finds an index on the columns that are used for filter and join it can make the retrieval faster, otherwise it would have to search through the table.

Note

Reference article on index:

I would strongly recommend reading the article on index(s) available at http://technet.microsoft.com/en-us/library/cc966523.aspx. This is the best ever article I have read on index(s); although for SQL Server 2000 it is equally true and applicable for any other version of SQL Server. The following are some more ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required