| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: View performance
"Martin Dick" <martin.dick_at_neis.com.au> wrote:
>stegri_at_rocketmail.com wrote ...
>| Does anybody know if using views instead of tables affects performance?
>| I've heard that view are in some way 'compiled' (although I don't
>| understand what is there to be compiled) and are even more efficient
>| than retriving columns as 'normal' select-stmts.
>As far as I know, the only real advantage in using a view is that the SQL is
>maintained centrally, and one which joins a lot of tables will mean that
>less SQL text has to be sent over the network to the server, thus reducing a
>possible bottleneck there.
One big advantage is that complex SQL in a view can be tuned for the most efficient access. Then developers or end-users can reference the view rather than re-inventing a potentially complex or poor-performing SQL statement.
I used to do this a lot - if I wrote some really complex SQL, I would create a view of it and encourage the developers to use these views in their reports. Saves a lot of hassle for the developers, and I knew the access path was the proper one.
Chris
 |
 |