Home » SQL & PL/SQL » SQL & PL/SQL » Materialized Views
Materialized Views [message #287668] Thu, 13 December 2007 01:38 Go to next message
bhupinderbs
Messages: 67
Registered: July 2006
Location: Bangalore
Member
Hi,
This is just to share with all of you.

Materialized Views can create magic in your applications as for as performace is concerned.

Attached herewith a SQL file to compare normal view and materialized view.

Bhupinder Singh
Re: Materialized Views [message #287670 is a reply to message #287668] Thu, 13 December 2007 02:04 Go to previous message
MarcS
Messages: 312
Registered: March 2007
Location: Antwerp
Senior Member
Did you also try to update/delete/insert rows from your x3_bhs_mv_big_tab table?

Maybe you should add following sequence to your test-case:

UPDATE x3_bhs_mv_big_tab <some rows> ;
COMMIT ;

DELETE x3_bhs_mv_big_tab <some rows> ;
COMMIT ;

INSERT INTO x3_bhs_mv_big_tab <some rows> ;
COMMIT ;



Previous Topic: last day of first week in a month
Next Topic: no record fetched
Goto Forum:
  


Current Time: Fri Dec 09 13:56:35 CST 2016

Total time taken to generate the page: 0.20025 seconds