Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a primary index and a
secondary index? What is a duplicate data entry in an index?
Can a primary index contain duplicates?
- 5 Answers
- 32280 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sanjib sarkar
Index is a set of <KEY,ADDRESS> pair. Now in the case of
Primary Index both keys and addresses of the records are
kept in order to search a particular record faster but in
the case of Secondary Index only the addresses of the
records are kept in the index not the key.
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
What are the types of database model?
How long can an error message be in raiseerror function?
In which table collections errors are stored.
Explain about a primary key?
What is dbms and its application?
Write short notes on manual refreshes.
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
I have a few records all are same structures data, I want to store data in multiple targets how
Explain the cube operator?
Explain about the hierarchical model of the database?
Which four data types cannot be used as a return type from a user-defined function?
Can an extended stored procedure be called from inside a user-defined function?
Which data type cannot be used as a parameter in a udf?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
