I'm currently working on a particular table that is about 7 million records. Size on disk is about 2GB. It so happens that the way this is indexed, The size of the index is about double the size of ...

Indexing is a critical part of database optimization. Indexing can dramatically increase query speed. However, DBAs still struggle with finding optimal indexes or optimal SQL plans. DBTA held a ...