what is materialised view? why we use it in data warehousing?

Answer Posted / manoj

Materialized view contains special cache to store the data
and structure of the table.

it improves the perrformance becuase when we write the
query every time data is not feched from the base table
i.e. we will use in Datawarehouse.

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between drill through, drill across?

580


what is log in cognos?

666


Define cognos report net?

568


What is a Framework manager?

565


What are slice and dice?

532






How to publish a package by running Java Script?

1604


Define query items?

598


Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

1600


Can you define framework manager?

627


What do you mean by query studio?

516


where you can save the report net documentation in our local system?

644


what is online view?

1524


What is model?

559


Can you define set to be cardinality?

591


------------------What is Inline Query?

1794