Thursday 19 March 2009

Hints in Oracle

Funny thing... I used to add any hints within block comments i.e. /*+ index(whatever) */, so never thought that line comment -- make it.
Does it? Sure it does --+ index(whatever). The only thing is one can not continue a SQL statement with it on the same line.