3 ms·
What's the difference between a query hint and a planner hint? > automatic planner adjustment when true cost was off More often than not, this "automatic adj
by castorp 6y ago
What's the difference between a query hint and a planner hint?
> automatic planner adjustment when true cost was off
More often than not, this "automatic adjustment" makes things worse.
> active-active clustering with RAC
But it's still shared storage, which doesn't really make it a true cluster in my opinion
> out of the box backup tooling
While this is true, there are several (free) backup tools that are easy to install and use and can rival rman's features.
- aeyes 6y agoA query hint is a clause you put into the query to make the planner execute the query in a certain way. Planner hint might not be the right term, Oracle has tools to show you different execution plans and to force a plan without touching the query on the application side. I'm not sure why shared storage would be a problem, the world runs on SANs and making them redundant is pretty much a solved problem. For running a RAC cluster you are required to have at least two network paths for each cluster node. Furthermore cluster communication is separated from storage communication.