No indexes found
Closed this issue · 5 comments
ShaneZhengNZ commented
No matter which database I connect to, local MSSQL database or Azure SQL database. I always get 'No indexes found'.
Thoughts?
GeoMac1313 commented
Set the minimum index size filter to 0 MB in Settings. Then rescan your databases. I have about a dozen test databases with very small index sizes so the same thing happened to me.
sergiisyrovatchenko commented
Do you checked settings? BTW, indexes where rows = 0 always ignored.
ShaneZhengNZ commented
@GeoMac1313 Thank you. The minimum size filter set to 0 fixed the issue.
ShaneZhengNZ commented
@sergeysyrovatchenko I would suggest that the minimum size filter default should be 0?
sergiisyrovatchenko commented
Minimal size (6...8Mb) of index is set up by performance reasons. In common case it's a bad idea for OLTP databases.