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
- 4833 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 |
How do I find my oracle client driver version?
Find all employees in Dept “Marketing”.
How can we find the size of a database?
how can we write trigger in trigger???????? can we write one trigger on two table???
what are steps for interface? where is exchange rate defined in which table?
Explain a data segment?
How to create additional tablespaces for an new database?
Can group functions be used in the order by clause in oracle?
What are the different types of database objects?
What happens if the update subquery returns multiple rows?
Which Department has MOST NUMBER of employees?
8 Answers IBM, LeadSquared, Mastek,
Explain the importance of .pll extension in oracle?
Oracle General 
