Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ashok naik
Yes that is called indexed views using this we can improve
Query performance if your view contain single select
stament then we can easily establish unique clusterd index
| Is This Answer Correct ? | 63 Yes | 20 No |
Post New Answer View All Answers
What do you know about normalization? Explain in detail?
How to create a stored procedure in oracle?
How to create a table in a specific tablespace?
What is ordinary table in oracle?
How to delete a column in an existing table in oracle?
What is an oracle and why it is used?
Explain the use of ignore option in imp command.
What is a static data dictionary in oracle?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
What are the ways tablespaces can be managed and how do they differ?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
State the difference between a primary key and foreign key?
What is dynamic proxy?
What are the attributes of the cursor?
Why do you use stored procedures and state some of its disadvantages?
