Index compression in sql server 2008

Question

Is there any way to perform index compression just like data compression in sql server 2008? If yes.please give me suggestion... Thanks in advance.

Sanjeeb Lenka · Answer

check this link http://stackoverflow.com/questions/16988326/query-all-table-data-and-index-compression

Ravi Shekhar · Answer

actually when i use data compression it reduces data space but still index size of that particular table is more than 200 mb . Thats y i am looking for index compression.

Sanjeeb Lenka · Answer

hi i don't know about this index compression but i found a link you can check this it may help you. http://weblogs.sqlteam.com/peterl/archive/2010/06/17/SQL-Server-2008-Compression.aspx http://blog.sqlauthority.com/2010/03/01/sql-server-data-and-page-compressions-data-storage-and-io-improvement/