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

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

Can we create index on views?

Question Posted / ashok naik

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

Is insert autocommit in oracle?

1063

What is oracle host variable?

1047

Explain the use of indexes option in exp command.

1136

how to clone 9i Database on to 10g Database.

2331

How to empty your oracle recycle bin?

1017

How to assign values to data fields in record variables?

1026

What do you mean by merge in oracle and how can we merge two tables?

1047

How to use existing values in update statements using oracle?

1055

What is the Tune Query

2284

What are the system predefined user roles?

1035

Is oracle a programming language?

979

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1925

What is partitioned table in Oracle?

1180

What are internal user account in oracle?

996

What are the different types of record groups in oracle? Explain each of them

1020