Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How can Oracle Materialized Views be used to speed up data
warehouse queries?

Answer Posted / svs rajesh

In oracle materialized view carry the carry with them so it
is easy 7 faster to retrieve the data for reporting instead
of goin to the actual database these provide the faster
retrieval of data.

Is This Answer Correct ?    6 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to pivot row data using informatica?

874


Where the applications and where

870


hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit

1982


Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?

896


What are the methodologies of data warehousing?

922


How many project sources we can create in metadata?

1008


How we are using this function?

1041


What are the key features of chameleon that separates it from other algorithms?

1060


What is the difference between Datawarehouse and OLAP?

884


What is the advantages data mining over traditional approaches?

905


What is a data profile?

907


what are the other factors of the database on which the loading performance depend?

1850


Explain what are the advantages data mining over traditional approaches?

1081


What is scd1 , scd2 , scd3?

1033


Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?

940