Ques. on adding constraints as opposed to indexes

hi all, i've just run into a situation where i wanted to drop the indexes and do large deletes on a big table, and then rebuild the indexes. so far so good for my first index, it ran pretty fast. but my other three indexes are in the form of constraints, and these run for hours and hours. when i looked at the index building, i saw the usual for a 7.X engine which is lots of scan threads. but later when i looked at the constraint building, i saw only an sqlexec thread for the add constraint. what is going on here? it appears that the engine is not running multiple threads for adding the constraint, and hence it is taking much longer. it seems to me that even though checking has to be done in the case of unique constraints, this is done at the last level, after the xchng threads have passed all their data up. any clue as to why this is only using one thread to do the work here? thanks, mickm -- _____________________________________________________________________________ Mickey Mestel mickm@netcom.com -on a beach in thailand to a beautiful, stoned, norwegian woman: "..yeah, it's just another foreign country without ice." -----------------------------------------------------------------------------