Re: Update Statistics Speedup Help???

In article <34BAFF4B.73BB@cyberramp.net>, Greg <greg@cyberramp.net> writes >Maybe we should start an SAP annex to the FAQ??? It's a very different I have the FAQ in two forms on my Web site, one is the individual Web pages in a browseable format (so you can check something quite fast and see what is new). The other is a compressed version of the whole thing which I'd expect people to download. I expect few people would want to spend the extra time downloading all the SAP pages in the big bundle. I expect that the SAP info would get quite large. I'd be happy to maintain an Informix-SAP FAQ on the primary site. I'd like to learn SAP and this would be a good way to do so...can anyone give me some pointers on SAP? I'll join the mailing- list.. >critter to handle - out of the box the system typically installs > >10,000 tables controlled via its data dictionary and Open SQL >preprocessing, which ends up in the form of >8000 tables that the DBMS >sees. Yes - that means some tables are pooled into single DBMS tables !!!! Gulp! >- goes back to the days when RDBMS'S couldn't handle so many tables.... >I might be able to name 30ish of them on a good day. It comes with What sort of names, x001 x002 x003??? -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care