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
What is SQL access advisor in Oracle?
How to write text literals in oracle?
How to connect asp pages to oracle servers?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
How many types of segments in Oracle?
How to create a new table in oracle?
what is normalisation?what are its uses?
How to pass parameters to procedures?
What happens if recursive calls get out of control?
How to list all user accounts in oracle?
How to apply filtering criteria at group level in oracle?
What are the differences between number and binary_float in oracle?
What happens to the current transaction if the session is ended?
How to unlock the sample user account in oracle?
How to export several tables together?