Collecting table statistics

From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
Date: Fri, 21 Jul 2000 10:46:20 -0700 (PDT)
Message-Id: <10565.112666@fatcity.com>

--0-846930886-964201580=:7528

Content-Type: text/plain; charset=us-ascii

Some time ago I thought I saw something on the list about 8i having the ability to automatically collecet statistics on tables with needing to issue the ANALYZE TABLE command. Can someone tell me how this works or point me to a document that describes it? Is this what the MONITORING clause of ALTER/CREATE table is for?

---

Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from anywhere!
--0-846930886-964201580=:7528

Content-Type: text/html; charset=us-ascii

<P>Some time ago I thought I saw something on the list about 8i having the ability to automatically collecet statistics on tables with needing to issue the ANALYZE TABLE command. Can someone tell me how this works or point me to a document that describes it? Is this what the MONITORING clause of ALTER/CREATE table is for?</P><BR><BR><p><br><hr size=1><b>Do You Yahoo!?</b><br> Get Yahoo! Mail - Free email you can access from anywhere!
--0-846930886-964201580=:7528--
Received on Fri Jul 21 2000 - 12:46:20 CDT