Answer Posted / karthik
clear short article about Indexed View
http://mssqltipsandtricks.blogspot.com/2012/01/index-on-views.html
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain the function of optimizer in oracle?
What is a user role in oracle?
Explain about your project and its relation to the current job position you are applying to?
What is recovery manager(rman) backup in Oracle?
Difference between open_form and call_form in oracle.
Why should I use oracle database?
How do I escape a reserved word in oracle?
Explain the use of analyse option in exp command.
Explain what are the different type of segments?
How can Oracle users be audited?
What are the major difference between truncate and delete?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
How do we create privileges in oracle?
How to use "in" parameter properly?
How to divide query output into groups in oracle?