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

Answer Posted / janaka

Yes we can create Indexed view.
use
CREATE UNIQUE CLUSTERED INDEX i_IndexA

ON View_Name(field1,field2)

Is This Answer Correct ?    55 Yes 35 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Name the three major set of files on disk that compose a database in Oracle?

1063

How to define and use table alias names in oracle?

883

Explain the difference between a procedure and a function?

1085

What to do if the binary spfile is wrong for the default instance?

998

How to rename an existing table?

1048

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2173

What is oracle database client?

974

What is save point in oracle database?

1239

what are actual and formal parameters?

1048

How to apply filtering criteria at group level in oracle?

985

What happens if you use a wrong connect identifier?

978

What is key preserved table?

959

How to run create database statement?

975

What are the various oracle database objects?

1090

How to calculate date and time differences in oracle?

991