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

What is a functional dependency f said to be minimal?

1166


What are the difference between snow flake and star schema?

1061


How can you clear the cache?

1058


What is the function of surrogate key in data warehousing?

1137


Explain how to export mappings to the production environment?

1025


For faster process, what we will do with the universe?

1032


How to performance tune reports?

1264


What is fact less fact table? Where you have used it in your project?

1083


What is a real-time data warehouse?

1036


Where the applications and where

968


What is a linked cube?

1047


Explain what is the advantages data mining over traditional approaches?

1077


What is data validation strategies for data mart v?

1175


Explain how to get the first 100 rows from the flat file into the target?

1028


What are target types on the server?

1041