Can we create index on views?

Answer Posted / deepak

We can create indexes on materialised views

Is This Answer Correct ?    48 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

is there a tool to trace queries, like profiler for sql server?

595


What are the set operators union, union all, minus & intersect meant to do?

560


What is the difference between view and materialized view in Oracle?

603


How to lock and unlock a user account in oracle?

610


What is index-organized table in Oracle?

568






How to sort the query output in oracle?

608


Will you be able to store pictures in the database?explain.

536


What is the meaning of recursive hints in oracle?

530


How do I manually create a database in oracle?

538


How do I spool in oracle?

539


Describe varray?

584


How to best split csv strings in oracle 9i?

584


What is bulk collect in oracle?

549


What is the relation of a user account and a schema?

611


How to shutdown your 10g xe server?

616