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

Answer Posted / hafiz

Yes we can create index on a view becuase the view may be
creates on subquery also and then the retrival of records
may be complex and therefore there must be an index on that
perticular column.

Is This Answer Correct ?    16 Yes 17 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain a synonym?

969

What is varray?

1028

What is tns name?

927

What is not equal to in oracle?

947

What is oracle host variable?

977

How to speed up webrick?

1004

How to name query output columns in oracle?

1129

How can I create database in oracle?

958

Explain the use of analyse option in exp command.

1063

 How to use an oracle sequence generator in a mapping?

1015

Explain how you would restore a database using RMAN to Point in Time?

2091

Respected sir, Please send me technical questions related to oracle apps..

1756

How to create a stored procedure in oracle?

1026

How to loop through data rows in the implicit cursor?

1011

Explain the use of constraints option in exp command.

988