When can Hash Cluster used ?



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

Post New Answer

More Oracle General Interview Questions

What is ceil and floor in oracle?

0 Answers  


when a grant option is encountered for a table EMP to a peer sitting beside you who has already having the table of that name (EMP), then what is the result?

2 Answers  


What privilege is needed for a user to delete rows from tables in another schema?

0 Answers  


i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

0 Answers   eicc,


What is the difference between pre-select and pre-query?

0 Answers  






What is the difference between "as" and "is" in an oracle stored procedure?

0 Answers  


emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example

1 Answers  


How much memory your 10g xe server is using?

0 Answers  


How to view the tablespaces in the current database?

0 Answers  


What happens if the imported table already exists?

0 Answers  


How to find no of saturdays in a month using single sql ?

2 Answers  


What is oracle server autotrace in oracle?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)