What is Hash Cluster ?
Answers were Sorted based on User's Feedback
Answer / orawhiz
A row is stored in a hash cluster based on the result of
applying a hash function to the row's cluster key value. All
rows with the same hash key value are stores together on disk.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / raja
as well as partitions
partiotions:a large table divided into more manageble
pieces each pieces is called partition.
without no logic automatic stored ttaht is called hash
partitions
| Is This Answer Correct ? | 0 Yes | 0 No |
How to convert dates to characters in oracle?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
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)
How to add another datafile to a tablespace?
if you update view? where we store the data?
How to write an inner join with the where clause in oracle?
Is the After report trigger fired if the report execution fails ?
how to clone 9i Database on to 10g Database.
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3
How to calculate date and time differences in oracle?
What suggestions do you have to reduce the network traffic?
How to concatenate two text values in oracle?