Re: Query performace against View or Table.

Jong

Suggestion, if you were to use a materialised view, then the query on the view would be very quick. However, as materialised views store a complete copy of the viewed data, you would have to allocate enough extra space in your tablespace.

Regarding your existing setup, using the view will still result in a query on the table, views are for all intents and purposes prebuilt sub-queries. What you should be more concerned with is does your view make effective use of any indexes you have. Views are more of a convenience thing to simplify users queries... nothing to do with any real performance improvements.

Regards

Fraser McCallum
MVP Oracle
www.brainbench.com

"Jong Ahn" <j_g_ahn_at_hotmail.com> wrote in message news:12310e11.0111070610.6c74186a_at_posting.google.com...
> Hi
>
> I'm looking for better way to query data.
>
> There are 2 million rows in 'Shipping' table and 'Today_shipping' view
> has only 2500 records. 'Today_shipping' is a view which select only
> today's shipments based on 'Shipping' table.
> Which is better doing query against View or Table?
>
> Thank you very much for your help.
>
> Jong
Received on Wed Nov 07 2001 - 08:34:45 CST