Answer Posted / 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 |
Post New Answer View All Answers
Please explain oracle data types with examples?
What are the different oracle database objects?
Can we connect to ORACLE db using Windows Authentication?
How is it different from a normal table?
How to define a variable of a specific record type?
What is a read write transaction in oracle?
What are the different editions of oracle?
What the is the diff between local index and global index. give some example.
State and explain the different types of data models?
How to delete a column in an existing table?
Please explain compound trigger in oracle?
How to use "for" statements in oracle?
types of indexes and the rationale behind choosing a particular index for a situation.
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
What is the quickest way to export a table to a flat file?