question

Slick84 avatar image
Slick84 asked

What is an Index's "Cached Size"?

Hi,

I'm looking at a custom report I found online here called "Top 20 indexes in cache". I need to know what does the last column mean? Its the "Cached Size mb" of an Index.

Is a lower number better? A higher number better? If any one can point me to the right direction, i'll highly appreciate it.

Thanks in advance,
Slick.

indexes
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered

To my knowledge, cache size is literally how much of the data is stored in the cache. As to whether or not a value is good or bad is just too depedent on the amount of memory available, whether or not the data in the cache is being accessed regularly or not. So it's primarily going to depend on individual circumstances.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.