⟩ Tell us what is an Index?
An index is used to speed up the performance of queries. It makes faster retrieval of data from the table. The index can be created on one column or a group of columns.
Question and Answer:
Home Database Developer
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
what is the difference between normal select query and currosor
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row . What was the logic?
I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables.
Can i insert bulk records into a db2 table using qmf of spufi only.
Can you search give an array in the WHERE clause of a db2 query?
could you give me an example how, where i code CHECKPOINT and restart. I need and example
Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
What is DCLGEN ?
Can GROUP BY and ORDERED BY used in a single query?
