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

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

1708


How to use "if" statements on multiple conditions?

729


What is private procedure oracle?

536


What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

1814


What are the types of partitions in oracle?

545






How to use null as conditions in oracle?

592


Can you have more than one content canvas view attached with a window ?

1820


How to rename a tablespace in oracle?

629


How to retrieve values from data fields in record variables?

579


How to start your 10g xe server?

605


Explain about your project and its relation to the current job position you are applying to?

551


Explain oracle left join with an example?

594


Explain cascading triggers.

578


What are a collation and state the different types of collation sensitivity?

560


How many types of synonyms in Oracle?

607