When can Hash Cluster used ?
Answer / orawhiz
Hash clusters are better choice when a table is often
queried with equality queries. For such queries the
specified cluster key value is hashed. The resulting hash
key value points directly to the area on disk that stores
the specified rows
| Is This Answer Correct ? | 1 Yes | 0 No |
Query to get max and second max in oracle in one query ?
34 Answers CTS, Keane India Ltd, TCS, Wipro,
What is mean by Program Global Area (PGA) ?
if you ctreate table identity
List out the components of logical database structure of oracle database.
Explain an index?
What is analyze command used for?
what is candidate key & super key
What is a OUTER JOIN?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
What is a sub query? Describe its types?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table