What is Hash Index?
Answer / pinkey
A Hash index stores key value pairs based on a pseudo
randomizing function called hash function
Is This Answer Correct ? | 0 Yes | 0 No |
How to assign a table row to a record variable?
What is the max number of columns in an oracle table?
Explain an index?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How to view the dropped tables in your recycle bin?
How to convert characters to times in oracle?
1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
how to genarate random numbers in oracle for particular row?
What is the usage of save points in oracle database?
What privilege is needed for a user to create views in oracle?
Explain the use of constraints option in exp command.