Archives
-
Oracle SQL hints
/*+ hint */ /*+ hint(argument) */ /*+ hint(argument-1 argument-2) */ All hints except /*+ rule */ cause the CBO to be used. Therefore, it is good practise to analyze the underlying tables if hints are used (or the query is fully hinted. There should be no schema names in hints. Hints must use aliases if […]
Apr 2nd, 2009 | Filed under Applications Performance Tuning, Database Performance Tuning, Oracle, Oracle DBA
Recent Comments