I've moved...

This blog now has a new home - please update your shortcuts and readers to: www.jeffkemponoracle.com. Sorry for any inconvenience!

Saturday, August 29, 2009

Two questions about stored outlines

Out of a discussion with a colleague at work I had two questions to answer:
  1. Can a stored outline change a query - e.g. the FROM or WHERE clauses?
  2. If a stored outline hints the query to use a function-based index, and a user doesn't have execute privilege on the function, what happens if the user runs the query?

[Full Article]

No comments:

Post a Comment

Note: only a member of this blog may post a comment.