Can we create index on views?

Answer Posted / mahesh kumar

we can never create index on view, becasue view doesn't
have physical memory. If we try to create index on view in
oracle, produce error: a view is not appropriate here

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1694


How can you merge two tables in oracle?

738


What is bulk collect in oracle?

755


What is difference between cartesian join and cross join?

796


Can we commit inside a function in oracle?

726


How to get last row id?

740


What are the restrictions in a oracle read only transaction?

765


List out the components of logical database structure of oracle database.

792


How do I call oracle stored procedures that take no parameters?

780


What are the oracle built-in data types?

755


What is the minimum client footprint required to connect c# to an oracle database?

774


Explain the use of online redo log files in oracle.

775


How to sort the query output in oracle?

810


What are the most common interview questions on ETL Testing for experience?

844


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1854