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
- 4740 Views
- I also Faced
- E-Mail Answers
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 |
What is the difference between Sleep and Wait? (Java)
If server is in US and client is in india there is timezone is diffrence, How can we display date in indian time when data is displayed from US server timezone?
What is columnar storage what is the advantage?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
How to name query output columns in oracle?
Describe the different type of Integrity Constraints supported by ORACLE ?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What are named parameters?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
How to check database size in Oracle?
how to find full database size
1 Answers BirlaSoft, Consultancy,
what is the difference between table and veiw?
Oracle General 
