Can we create index on views?

Answer Posted / ramon

With schemabinding
the view have to be attache with schemabinding on it. Yes it is possible

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the use of indexes option in exp command.

599


What is a procedure in oracle?

622


What is a subquery?

620


What are advantages of dateset in datastage?

1757


What is user managed backup in Oracle?

618






In the oracle version 9.3.0.5.0, what does each number shows?

760


Why do we use bulk collect in oracle?

579


How to create an oracle database?

596


If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

1741


What is parameterized cursor in oracle?

584


What is tns name?

549


What is a select query statement in oracle?

551


What are the roles of dba?

617


how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1539


Describe an oracle table?

580