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 / deepak

We can create indexes on materialised views

Is This Answer Correct ?    48 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the oracle differences between nvl and coalesce

1150


How to count duplicated values in a column in oracle?

1050


Is primary key indexed by default in oracle?

992


Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1788


Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2148


How to rebuild an index in oracle?

1028


Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1885


What is the disadvantage of User defind function?

2296


What are the ansi data types supported in oracle?

948


How to get a create statement for an existing table?

974


Where do we use decode and case statements?

1018


What is the difference between I and G in Oracle?

1099


How to export your own schema?

1011


Explain about the analyze command in oracle?

1056


How to rename a column in an existing table?

1037