Answer Posted / kamala k n
view is virtual table and index is created on table columns which is performance the query
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How do we display rows from the table without duplicates?
Difference between hot backup vs. Cold backup?
How to name query output columns in oracle?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
How remove data files before opening a database?
What is a table index in oracle?
How to retrieve values from data fields in record variables?
What types of joins are used in writing subqueries?
What is a package ? What are the advantages of package ?
How to rename an existing table?
Explain the use of analyse option in exp command.
What is Trigger in Oracle?
What are data pump export and import modes?
How will you differentiate between varchar & varchar2?