-
A few months ago when I was working with Oracle in a data warehouse, I came across hints . Basically these are statements in the below form /*+ hint */ /*+ hint(argument) */ /*+ hint(argument-1 argument-2) */ placed inside your query to manipulate the oracle optimizer to optimize a query's execution...