I saw a comment from @RicardoPontual that mentioned density-based index hints
Your question seems pretty confusing .. it starts with a very basic thing such as "how do I do a procedure on sql server", which is too simple for find on Google and ends up talking about index hints based on density , something very advanced, does not make much sense to me
This gave me some doubts, I know them:
- What are hints of index?
- What are density-based hints ?
- Are there other types of hints ?
- Would it be possible to add examples, regardless of the database?
obs¹: If you have something more on the subject, feel free to add
obs²: If I used some term incorrectly, you can correct it in the question