vanessa4biz (2/16/2014)
I am trying to defrag indexes on user databases. I don't believe heap tables have indexes.
Heap tables can have indexes. Heaps can become fragmented too and should be given some TLC too.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events