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

no we cann't create an index on a view.why because view is
a virtual table.when u select the view it will get the data
from base(database)table.
view is a stored query.so we cann't

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is oracle open database communication (odbc)?

1083


What is difference between truncate and delete?

1096


What is redo log?

1114


what is normalisation?what are its uses?

2329


What is coalesce function?

1146


What do you mean by redo log file mirroring?

1069


How do I connect to oracle?

1080


how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2600


What are the different pseudo commands? Explain in general?

1124


How to open and close an explicit cursor in oracle?

1096


What is bulk copy or bcp in oracle?

1184


How to save query output to a local file?

1085


Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1894


What is the maximum number of triggers that can be applied to a single table?

1068


Why do we need oracle client?

1008