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 / mahesh kumar

we can never create index on view, becasue view doesn't
have physical memory. If we try to create index on view in
oracle, produce error: a view is not appropriate here

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a partition in oracle?

1207


What is a procedure in oracle?

1282


How to put more than 1000 values into an oracle in clause?

1085


Explain drop constraint oracle?

1121


In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1984


How to define an anonymous procedure without variables?

1196


Explain oracle data types with examples?

1081


How remove data files before opening a database?

1135


What are the varoius components of physical database structure of oracle database?

1041


What is meant by raw datatype?

1118


Explain do view contain data?

1052


List out the components of logical database structure of oracle database.

1095


What is rich query?

1037


types of indexes and the rationale behind choosing a particular index for a situation.

2559


Is oracle a relational database?

970