You can translate the question and the replies:

Index on cache table created in MSSQL

Hi, When i open the cache database in SQL , i see lot of Heap tables where there is no index created. Can i go ahead and create clustered indexes on that.. Will that help us to improve cache load performance
06-01-2017 10:36:12 -0500

1 Answer

Hi, I would normally use a cache index to improve the performance of retreiving the data from my cached views. Creating clustered indexes on your cache database in MSSQL does not guarntee any improvement in the cache load performance. Hope this helps!
Denodo Team
09-01-2017 11:37:33 -0500
You must sign in to add an answer. If you do not have an account, you can register here