Performance on large tables

Data volumes are exploding in every business where a Database or BI professional might find himself. Subsequently data warehouse and decision support systems to keep up with this growth,  and are expected to perform at the same levels while offering even deeper insights into what the data is actually saying.

SQL Index Fragmentation

SQL Indexing

Indexes are applied to tables to better performance in query execution, instead of the database engine searching through each and every row for the queried data, indexing provides an indexed subset of data that can be queried to get the required rows.