Runstats will help the select decide which is the best access plan. You should
run it atleast every other day with this growth. It will help.



Quoting seshagirirao <db2udbdba-ezmlmshield-x67041752.[Email address protected]

>
> I have a table T1 with 30 columns and 400 bytes length. Primary index is
> defined on 9 columns and duplicate index is defined on 10 columns.
> On daily basis 5000 records gets added to this table. As on 26,october the
> row count is 1,50,000
> The Syscat.Table is giving the row count of 50,000 for the table T1 as last
> RUNSTATS are done on Sep 28 .
> My select queries are slow when I am using this table.
> How frequent RUNSTATS needs to be done on this table ?
> How to improve the performance of my selects ?
>
>
>
>
> The information contained in this electronic message and any attachments to
> this message are intended for the exclusive use of the addressee(s) and may
> contain proprietary, confidential or privileged information. If you are not
> the intended recipient, you should not disseminate, distribute or copy this
> e-mail. Please notify the sender immediately and destroy all copies of this
> message and any attachments.
>
> WARNING: Computer viruses can be transmitted via email. The recipient should
> check this email and any attachments for the presence of viruses. The company
> accepts no liability for any damage caused by any virus transmitted by this
> email.
>
> www.wipro.com
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>




----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

DB2 & UDB email list listserv db2-l LazyDBA home page