• OK, I didn't read your question properly so sorry about that.

    That said......

    Information related to non-clustered indexes are stored as a view in the MASTER database named sys.partitions. This information is stored on disk and not in memory so it still makes your question about information stored in memory moot.

    Hope that helps!