Re: few questions

In article <3647B12B.DA116448@hotmail.com>, June Tong <june_t@hotmail.com> writes >Schaeflein, Paul wrote: > >> Regarding #1: How would the load command know what columns to create? What >> data types? > >Yup. Good point. > > >> Regarding #3: To see a reduction, you would have to unload/drop/load or run >> the ALTER FRAGMENT statement. > >This I don't agree with. Even though any freed pages are not returned to the >free pool, the ti_npdata value should still reflect the number of data pages >actually in use. That is, if one deletes all the rows in the table, the >ti_npdata should go to 0, even though all the pages allocated to the table are >not released. The only reason I can think of why ti_npdata would not go down >after deleting a large number of rows is that you have managed to delete all >these rows without actually freeing up any data pages. That is, you have >managed to leave at least one remaining row on every data page that was >allocated. OnLine does not re-organize your rows to fit them onto fewer pages >when you have deleted them. If you had 100 data pages used, and delete 99% of >your data, but by some fluke managed to do this in a way that leaves one row on >each page, then your ti_npdata will not go down. > >June >-- >june_t@hotmail.com >Grounded in Palo Alto, living on KitKat bars So you gave up the cookies then?? > -- 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