Performance with table millions of rows

[Simon Gilbert]

Hi all,

I have a database with a table containing millions of rows
(3600000). When I do a select on this table, the performance decreased
due to big volume of data. Does someone knows the solutions (an
overview only becaus I know that can be tricky).

Thanks

[Mark A]

"Simon Gilbert" <sp*****@hotmail.com> wrote in message
news:25**************************@posting.google.c om...

Hi all,

I have a database with a table containing millions of rows
(3600000). When I do a select on this table, the performance decreased
due to big volume of data. Does someone knows the solutions (an
overview only becaus I know that can be tricky).

Thanks

Please post the DDL of the table and the indexes. Then post the SQL of the
query that is slow.

Make sure you have executed runstats on the table and indexes. I would
suggest using the options to get distribution on key columns also.

Here is sample syntax for version 8 runstats:

RUNSTATS ON TABLE table_name ON KEY COLUMNS AND INDEXES ALL

[Blair Adamache]

1. add 1 or more indexes
2. runstats with indexes all and distribution all
3. read this: (or at least the top 10 section):

http://www-106.ibm.com/developerwork...-0404mcarthur/

Simon Gilbert wrote:

Hi all,

I have a database with a table containing millions of rows
(3600000). When I do a select on this table, the performance decreased
due to big volume of data. Does someone knows the solutions (an
overview only becaus I know that can be tricky).

Thanks