Re: How To: multi threads, Fragmentation in Online 7.1.

Jorge Torralba wrote: > > Another hint for performance, > If you are doing a lot of sequential scans, you may want to unfragment > your indecies and put them in a spearate dbspace. This should increase > performance somewhat. > >[Fancy Sig deleted for space ;-] Yes, when fraging a table you want to separate the index! The other thing to remember,that for n partitions of a frag'd table you want n frags of the index. There is/was a bug in 7.xx where PDQ would assign n processes to go through the table and if the number of frags in the index was < n, then all hell broke loose. [N is the number of VCPUs you allocated. or the number of frags. Whatever is smaller.] -Mikey