What are some characteristics of columns that benefit from
indexes?
Answer / s
primary key, foreign key, Joins are often performed on
primary and foreign key columns. columns frequently coded
in the WHERE clause, ORDER BY, GROUP BY, DISTINCT, columns
which are searched or joined over less than 5-10% of the
rows.
Is This Answer Correct ? | 0 Yes | 0 No |
What are union and union all?
What is QUIESCE?
What is db2 catalog database?
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..
select distinct(empid),distinct(dept),name from EMP will the above query work?
How to handle null values in db2
Where besides the DB2 catalog is database object information stored by DB2?
How to create db2 table in mainframe?
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
How do you retrieve the first 5 characters of firstname column of db2 table emp?
How to know the primary key of a table without defining the primary key in the table?
What is clone table?