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...

Can we create index on views?

Answer Posted / ashok naik

Yes that is called indexed views using this we can improve
Query performance if your view contain single select
stament then we can easily establish unique clusterd index

Is This Answer Correct ?    63 Yes 20 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4479


What are the restrictions on external table columns?

991


What is a table in oracle?

926


can u plz provide me oca sql dumps please i need them

1900


What happens to the current transaction if the session is killed?

925


What is oracle thin client?

972


How to invoke the original export import utilities?

973


Describe an oracle table?

987


How to speed up webrick?

1006


Explain the features of oracle?

989


What is a system tablespace and when it is created?

918


What is partitioned table in Oracle?

1104


When do I need to use a semicolon vs a slash in oracle sql?

1026


How to run queries on external tables?

988


Can sub procedure/function be called recursively?

945