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
- 4736 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
How to install oracle odbc drivers?
What does sharding mean?
How do I manually uninstall oracle client?
What is a sub query? What are its various types?
What are internal user account in oracle?
What is object data modeling?
Can we insert data in view oracle?
What is coalesce function?
What is the difference between online and offline backups?
How to handle a single quote in oracle sql?
How to create a testing table in oracle?
How do I learn what codesets are available in oracle?
How to store only time; not date and time?
What is the order of defining local variables and sub procedures/functions?
interview questions with answer for cts
