what are the things that you consider while creating indexes
on partitioning tables?
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 |
Can select statements be used on views in oracle?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
Explain the truncate in oracle?
Is primary key = unique key,not null? If yes,please explain IF No,please explain
Is the After report trigger fired if the report execution fails ?
How to create id with auto_increment on oracle?
What are the oracle differences between nvl and coalesce
i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?
What is tns name?
Explain how you would restore a database using RMAN to Point in Time?
WHT ARE THE AGGREATE FUNCTIONS?
How to use "startup" command to start default instance?