Where could you look if you had a question about whether a
column has been defined as an index?
Answers were Sorted based on User's Feedback
Answer / sadiq afroze
This information can be found in SYSIBM.SYSINDEXES
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / sushmitha
in our company we use Platinum tool.
in platinum for the option 1 - we can see if the column has
been defined as an index.
Is This Answer Correct ? | 2 Yes | 0 No |
assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
When Can you be sure that a query will return only one row?
my project is insurance management system,how to explain my work environment in interview?
Explain dclgen.
What is runstats and reorg in db2?
What is the advantage in De-normalizing tables in DB2?
What is explain plan in db2?
What is the FREE command?
Is db2 a mainframe database?
What is dbrm? What it contains?
What is a collection in db2?
How to find primary key of a table in db2?