what are the things that you consider while creating indexes
on partitioning tables?
Answer / gautam choudhury
1) If the table partitioning column is a subset of the
index keys, use a local index. If this is the case, you are
done.
If this is not the case, continue to guideline 2.
2) If the index is unique, use a global index. If this is
the case, you are done. If this is not the case, continue
to
guideline 3.
3) If your priority is manageability, use a local index. If
this is the case, you are done. If this is not the case,
continue to guideline 4.
4) If the application is an OLTP one and users need quick
response times, use a global index. If the application is a
DSS one
and users are more interested in throughput, use a local
index.
Is This Answer Correct ? | 1 Yes | 0 No |
Explain implicit cursor.
What is the function of Redo Log ?
What is enter substitution variable in oracle?
How to create id with auto_increment on oracle?
What is Data Dictionary Cache in Oracle?
What is SAVE POINT ?
How to create a new table by selecting rows from another table?
What is the difference between online and offline backups?
What are various joins used while writing SUBQUERIES?
How to define a data field as not null?
Can a property clause itself be based on a property clause ?
who is the father of oracle and send chodd rules