Index Hint

Index Hint - Index Is Dropped By DBA, What Will Happen Now

Index Hint – Index Is Dropped By DBA, What Will Happen Now?

Leave a Comment / Home, Sybase ASE

First of all, Let me state it upfront that hinting index is not a very good idea and could result in degraded performance. Index hint is not actually a hint rather we are ordering Database Engine to use the provided index however it is still called as “Hint”. In one of my earlier post, I …

Index Hint – Index Is Dropped By DBA, What Will Happen Now? Read More »

Why Index Hints Should Never Be Used(My Experience)

Why Index Hints Should Not(judiciously) Be Used(My Experience)

Leave a Comment / Home, Sybase ASE

I am sharing here my recent experience with one of our vendor who is considered as very much reputed and experienced, they have team of DBAs(development DBA cum Architect, Production DBA, Infrastructure DBA etc..) and mostly their database codes as well as their indexing are not disputable. I am the lonely DBA working in my …

Why Index Hints Should Not(judiciously) Be Used(My Experience) Read More »