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
- 4855 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 |
Difference between join and a subquery?
8 Answers Base Automation, NMDC,
How to pass parameters to procedures?
Can we create more than one constraint to column ?
What is merge statement used for?
How to run create database statement again?
What does `(+)` do in a where clause?
23. Display the client name for all clients who have placed an order where any order line has more than 3 items. Do not use a table join anywhere in your query.
How to build data dictionary view an new database?
How to recover a dropped index?
Explain oracle data types with examples?
how to get the no employee in each department including the dept which has 0 employee
What is the difference between "as" and "is" in an oracle stored procedure?
Oracle General 
