Good Day All,
When i drop a single index it should be always nIndexesWas :1 right ?
why its varying ?
does nIndexesWas → based on number of index or number of indexed document?
Thank you
The nIndexesWas value you see when you drop an index refers to the total number of indexes on the collection at the time the operation was performed —not the number of documents indexed or anything document-related. It represents the count of indexes on the collection before the index was dropped. nIndexesWas will vary because it reflects the total number of indexes before the drop operation—not just the one you’re deleting.
Hope this helps…
Sorry still unable to understand .
May be I’m confusing in relation to other rdbms .
For instance when I create an index on a collection lets say A , i thought its creating only 1 index → so drop of index should also be displaying nindexes=1
Kindly advise with document or use cases to understand more on this