http://en.wikipedia.org/wiki/Index_(database)
A database index is a data structure that improve the speed of operations in the table. Indexes can be created using one or more columns, providing the basis of both rapid random lookups and efficient ordering of access to records.
Architecture
Clustered or non-Clustered.
Column Order
Is very important.
Applications and limitations
reverse(email_address);
Types
Bitmap
Dense
Sparse
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment