SQL-Index | Varinder Sandhu

Effective Database Maintenance and Management – Index Fragmentation

Varinder Sandhu Guest Post, SQL, SQL-Advanced, SQL-Index

We have said before that indexes are easily the most important database structures insofar as database performance tuning is concerned. Therefore, you must pay keen attention to their configuration, structure and arrangement in order to get the best level of performance out of them. Theory of index fragmentation Fragmentation does not only occur at the file-system level and inside log files; data files can also be affected by fragmentation – specifically within the sections that store index and table data.

SQL – Index

Varinder Sandhu SQL, SQL-General, SQL-Index, Varinder Sandhu

UNIQUE Creates a unique index on a table or view. A unique index is one in which no two rows are permitted to have the same index key value. A clustered index on a view must be unique. The Database Engine does not allow creating a unique index on columns that already include duplicate values, whether or not IGNORE_DUP_KEY is set to ON. If this is tried, the Database Engine displays an error message. Duplicate values must be removed before

» Read more

Index, SQL, SQL - Index