Interested to Buy Any Domain ? << Click Here >> for more details...
what are the things that you consider while creating indexes
on partitioning tables?
- 1 Answers
- 4934 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain a data segment?
How to rename an index?
How to export your own schema?
Explain the use of analyse option in exp command.
what is dynamic SGA and static SGA
What is an oracle database?
What is the implicit cursor in oracle?
What are privileges and grants?
Explain implicit cursor.
Why do we use bulk collect in oracle?
How to run the anonymous block again?
Why is oracle used?
what is the use of system.effective.date variable in oracle?
How does one get the view definition of fixed views/tables?
What is a initialization parameter file in oracle?
