Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / hafiz
Yes we can create index on a view becuase the view may be
creates on subquery also and then the retrival of records
may be complex and therefore there must be an index on that
perticular column.
| Is This Answer Correct ? | 16 Yes | 17 No |
Post New Answer View All Answers
How to enter a new row into a table interactively?
What privilege is needed for a user to create views in oracle?
How to run queries on external tables?
List out the difference between commit, rollback, and savepoint?
How to apply filtering criteria at group level in oracle?
What is the difference between PFILE and SPFILE in Oracle?
What do you mean by merge in oracle?
Is oracle a language?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What is transaction control statement and how many types of transaction control statement in Oracle?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How to delete all rows a table in oracle?
What is the usage of analyze command in oracle?
what is insert all statement in sql
Explain the use of grant option in imp command.
