How do I optimize a query in db2?
No Answer is Posted For this Question
Be the First to Post Answer
What is explain in db2?
When can an insert of a new primary key value threaten referential integrity?
Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?
What is a root page?
What type of database is db2?
What does the CHECK Utility do ?
What are the various isolation levels possible?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
what types of copies can be made with the COPY Utility ?
What's The Percentage Free Space ?
What parameters are used to control the free space in DB2?
What are db2 tables?