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
- 4868 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 view?
How can I create database in oracle?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
what is dynamic SGA and static SGA
What is E-R diagram ?
2 Answers CGI, Keane India Ltd,
What is meant by a deadlock situation?
Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?
What is java oracle used for?
How to create index-by table in oracle?
How to define default values for formal parameters?
Difference between primary key and unique key ?
77 Answers Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions,
When can Hash Cluster used ?
Oracle General 
