When Can you be sure that a query will return only one row?
Answer Posted / s
A Matching Index scan with equal predicate on a Unique
index will return only one row.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is reorg and runstats in db2?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is reorg?
what is the sqlcode -501
What is deadlock in db2?
Mention the location where the output received from explain statement is stored.
How can you do the explain of a dynamic sql statement?
What is the reason behind not using select * in embedded sql programs?
How do you eliminate duplicate values in db2?
What is buffer pool?
What is the default page size of buffer pools?
What is ibm db2 connect?
What are db2 objects?
What is multi row fetch in db2?
How do I start db2 in windows?