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
- 4854 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
What is the usage of merge statement?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
What is the order of defining local variables and sub procedures/functions?
Is primary key indexed by default in oracle?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
How to enter a new row into a table interactively?
How many anonymous blocks can be defined?
What are the ansi data types supported in oracle?
how to clone 9i Database on to 10g Database.
How to delete multiple rows from a table in oracle?
How does the on-delete-cascade statement work?
What is ordinary table in oracle?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
What is a database schema in oracle?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
