Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What are some characteristics of columns that benefit from
indexes?



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

Post New Answer

More DB2 Interview Questions

What are union and union all?

0 Answers  


What is QUIESCE?

2 Answers  


What is db2 catalog database?

0 Answers  


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..

5 Answers   CTS,


select distinct(empid),distinct(dept),name from EMP will the above query work?

2 Answers   CTS,






How to handle null values in db2

4 Answers  


Where besides the DB2 catalog is database object information stored by DB2?

1 Answers  


How to create db2 table in mainframe?

0 Answers  


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.

3 Answers  


How do you retrieve the first 5 characters of firstname column of db2 table emp?

1 Answers  


How to know the primary key of a table without defining the primary key in the table?

5 Answers   Satyam,


What is clone table?

0 Answers  


Categories