I am using SQL Server 2014. I had an existing table with lots of indexes. I added a non clustered column-store index as a test. When I run test queries it ignores my new column-store index. I don’t know Why? Should I remove the old indexes, leaving just the column store?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!