Answer Posted / a.praveen kumar
It is a schema object to improve the performance of select statement which is using multiple database tables with standard join condition.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is oracle data type?
What is index-organized table in Oracle?
is there a tool to trace queries, like profiler for sql server?
What is Trigger in Oracle?
Explain drop constraint oracle?
Explain integrity constraints?
Calculate difference between 2 date / times in oracle sql?
Can objects of the same schema reside in different tablespace?
What is oracle and what are its different editions?
What is a named program unit?
How would you begin to troubleshoot an ORA-3113 error?
How to create a new table in oracle?
How to generate query output in html format?
How to convert csv to table in oracle?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?