1

I know that cluster index exist on the table itself, but where's the noncluster index and is pointer exist? I thought on "temp DB", but maybe i am wrong.

I did not find anything about it on the web.

Can you help me with it?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
ohad mesika
  • 79
  • 9
  • 2
    It exists on additional pages. In some databases, this would be a separate store of "index" pages. In some databases, it might be on data pages. – Gordon Linoff Mar 24 '17 at 11:58

1 Answers1

0

TempDb is a separate database, used by SQL (and maybe some of your stored procedures) to do intermediate work - hence the Temp in TempDb - so your indexes wouldn't be in there. Non clustered index pages go into the same filegroup as the clustered index pages by default - but you can specify which filegroup they go into on the index declaration. See, for example: Create Index.

Also, if you want to ferret out where the data is, start with sys.indexes and related system views.

Clay
  • 4,999
  • 1
  • 28
  • 45