Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

No indexes found #6

Closed
ShaneZhengNZ opened this issue Jul 19, 2019 · 5 comments
Closed

No indexes found #6

ShaneZhengNZ opened this issue Jul 19, 2019 · 5 comments
Assignees
@sergiisyrovatchenko
Labels
question Further information is requested

Comments

@ShaneZhengNZ
Copy link

No matter which database I connect to, local MSSQL database or Azure SQL database. I always get 'No indexes found'.

Thoughts?
@GeoMac1313
Copy link

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
Copy link
Owner

Do you checked settings? BTW, indexes where rows = 0 always ignored.

@ShaneZhengNZ
Copy link
Author

@GeoMac1313 Thank you. The minimum size filter set to 0 fixed the issue.

@ShaneZhengNZ
Copy link
Author

@sergeysyrovatchenko I would suggest that the minimum size filter default should be 0?

@sergiisyrovatchenko
Copy link
Owner

Minimal size (6...8Mb) of index is set up by performance reasons. In common case it's a bad idea for OLTP databases.

@sergiisyrovatchenko sergiisyrovatchenko added the question Further information is requested label Dec 17, 2019
@sergiisyrovatchenko sergiisyrovatchenko self-assigned this Dec 16, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@sergiisyrovatchenko sergiisyrovatchenko

Labels
question Further information is requested
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@ShaneZhengNZ @GeoMac1313 @sergiisyrovatchenko