Index VS Index Hint

hi all,

Ple anybody clarify index vs index hint…

which ll increase the peformance?

Bec many misunderstandings about this topic…I got some idea abt this from some blogs…but wen i saw this topic in Morphx IT material ,its totally contradiction…

anybody clear this


“index” is used for sorting, so it’s basically not used for performance optimization.

“index hint” instructs DBMS to use a specific index, but usually DBMS should be able to choose it itself (based on statistics of real data) - if it doesn’t, maybe it does not right information (= outdated statistics).

Thanks Martin…I got clear…