Relative Content

Tag Archive for sqlindexingdb2query-optimization

DB2 Index to cover JOIN, WHERE and GROUP BY

Does DB2 index cover JOIN, WHERE and GROUP BY columns. I have a query similar to below one which is not using the full index.