Please enable JavaScript.
Coggle requires JavaScript to display documents.
INDEXES BASICS - Coggle Diagram
INDEXES BASICS
Indexing Strategies
Prefix Indexes
left prefix for indexing BLOB or TEXT columns, or
very long VARCHAR columns
-
Index Selectivity
is the ratio of the number of distinct indexed
values (the cardinality) to the total number of rows
in the table (#T), and ranges from 1/#T to 1
-
-
-
Full-Text Indexes
-
for a text, char, varchar
-
-
-
-
-
What Are Indexes?
allows the SQL Server engine to
perform fast, targeted data retrieval
rather than simply scanning though the
entire table