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
- 30705 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / dinesh uikey
The primary index is on the field which specifies the
sequential order
of the file. There can be only one primary index while there
can be many
secondary indices.
| Is This Answer Correct ? | 12 Yes | 19 No |
Post New Answer View All Answers
What is the physical representation for a many-to-many relationship?
Can an extended stored procedure be called from inside a user-defined function?
How can you log an error to the server event log from a stored procedure?
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
Explain what a database is?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
How to generate OIDS
Explain the rollup operator?
Explain about normal forms?
What are the main phases of database development?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
How can you fix a poorly performing query?
Which data type cannot be used as a parameter in a udf?
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).
