title: Does Oracle View calculate fields you are not trying to query?
body: <p>I am trying to optimize the performance of a query. The problem is:
  Say we have view X. And it has attr A, B, C.
  C is a calculated field.</p>
  <p>Say I want to try to optimize by querying &quot;Select A,B from X where A = 'some condition'&quot; then if I need C I can calculate that later on with the much smaller subset of data to enhance performance.</p>
  <p>My question is will this help? Or does an Oracle view calculate C anyways when I make the initial query, regardless of whether I am querying for that attr or not? Therefore to optimize I would have to remove these calculated from the view?</p>