Exforsys

Online Training

Statistics Collection

This is a discussion on Statistics Collection within the DB2 forums, part of the Database category; I want to collect statistics about the data values in tables to decide the access path for the optimizer. How ...


Go Back   Exforsys > Database > DB2

Statistics Collection Statistics Collection

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply

 

LinkBack Thread Tools
  #1 (permalink)  
Old 12-18-2006, 02:39 AM
Senior Member
  
Join Date: Apr 2006
Posts: 122
rachelle is on a distinguished road
Statistics Collection
I want to collect statistics about the data values in tables to decide the access path for the optimizer. How can I do this. If there is any utility or command kindly mention the syntax for the same.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 12-19-2006, 03:33 PM
Senior Member
  
Join Date: Apr 2006
Posts: 145
Rahulbatra is on a distinguished road
RUNSTATS is the DB2 utility that is used to collect statistics about the data values in tables which can be used by the optimizer to decide the access path.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« Few More Environments | Is Facility Available »
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads

Thread Thread Starter Forum Replies Last Post
Perl Collection. cybot Perl 5 05-22-2006 10:56 AM
CSS Collection cybot Web 2.0 0 04-30-2006 01:30 PM
Python Collection cybot Python 0 04-28-2006 09:57 AM
I am looking for a discussion about wrapping Hugh table as collection Julia Software Patterns 0 06-28-2004 07:53 AM
Smalltalk FAQ (v.1.0) Vikas Malik Tech FAQ 0 04-17-2004 08:27 AM


All times are GMT -4. The time now is 11:03 PM.

Contact Us - Exforsys - Archive - Privacy Statement - Top

Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0
Copyright 2004 - 2007 Exforsys Inc. All rights reserved.