SQL 2016 - NU/NC Index Missing From sys.partitions Is there a reason that a non-unique, non-clustered index would have 0 corresponding records in the sys.partitions view?  There is a CI on the same table and there is a record for it in the view.  My understanding is that any NCI should have at least one record in sys.partitions.  Thanks.
A disabled index has no storage.