Create detached indices

I've noticed that creating a detached index takes a markedly longer period of time then creating an attached index. Just to test the theory (and to make sure I wasn't making a mountain out of a molehill), I started to create an attached index . . . here's the output: Informix Dynamic Server Version 7.30.UC10 -- On-Line -- Up 4 days 16:30:11 -- 271704 Kbytes session #RSAM total used id user tty pid hostname threads memory memory 2242 informix ttyp1 25581 whsprod1 5 188416 160488 tid name rstcb flags curstk status 2398 sqlexec cf672f14 Y-BP--- 33216 cf672f14 cond wait(opened_up) 2405 xchg_1.0 cf675000 Y-B---- 35776 cf675000 cond wait(packet_cond) 2406 xchg_2.0 cf675e1c --B-R-- 35776 cf675e1c running 2407 xchg_2.1 cf673d30 --B-R-- 35432 cf673d30 sleeping(secs: 2) 2408 xchg_2.2 cf674698 --B-R-- 35456 cf674698 sleeping(secs: 2) Memory pools count 2 name class addr totalsize freesize #allocfrag #freefrag 2242 V cfd4b018 73728 6368 396 1 2242_SORT_0 V d006d018 114688 21560 181 3 When I change the SQL to create a detached index, here's what I see . . . Informix Dynamic Server Version 7.30.UC10 -- On-Line -- Up 4 days 16:30:43 - 271704 Kbytes session #RSAM total used id user tty pid hostname threads memory memory 2242 informix ttyp1 25581 whsprod1 4 139264 77464 tid name rstcb flags curstk status 2398 sqlexec cf672f14 Y-BP--- 32640 cf672f14 cond wait(opened_up) 2410 xchg_1.0 cf675000 Y-B---- 35776 cf675000 cond wait(opened_up) 2411 xchg_2.0 cf674b4c --B---- 35240 cf674b4c running 2412 xchg_3.0 cf675e1c Y-B-R-- 35752 cf675e1c cond wait(free_cond) Memory pools count 2 name class addr totalsize freesize #allocfrag #freefrag 2242 V cfd4b018 106496 46912 381 10 2242_SORT_0 V d00bf018 32768 14888 25 2 Any particular reason why I can't get a larger number of threads involved with this index create?? -- John Carlson Informix DBA WHSmith USA #include std_disclaimer.h /* These are my opinions, not my company's opinion */