We have an Oracle 8 datawarehouse.
I have a question about accessing a view vs accessing a table directly. I was wondering if you could explain a bit about views and when they would be applicable.
We have a view that doesn't restrict access at the row level, but rather restricts columns. When we send a query against this view vs sending the same query against the actual table the performance difference is significant.
My question is, Are the instructions for the view run prior to the running of the query? Or is the query run against the view integrated with the view
instruction and run with one query?
Also, is the real power of a view when restricting by row rather than column?
I'd appreciate any thoughts/information anyone can supply.
Thanks.
I have a question about accessing a view vs accessing a table directly. I was wondering if you could explain a bit about views and when they would be applicable.
We have a view that doesn't restrict access at the row level, but rather restricts columns. When we send a query against this view vs sending the same query against the actual table the performance difference is significant.
My question is, Are the instructions for the view run prior to the running of the query? Or is the query run against the view integrated with the view
instruction and run with one query?
Also, is the real power of a view when restricting by row rather than column?
I'd appreciate any thoughts/information anyone can supply.
Thanks.