Art S. Kagel wrote:
>>Mark D. Stock wrote:
>>
>>>I would like to see at least three on any system, especially one making heavy
>>>use of temp tables. Preferably on different disks. Although that may be
>>>difficult with your striping.
>
> That requires further elucidation, Mark. Please!?!
Really? If I'm going to bother to fragment, then I like to do it with at
least 3 fragments. I like to have more than 2 temp dbspaces to be able to
spread the load of temp tables. It just becomes redundant doing it with
fragmentation, when the underlying striping lights up all the disks for
every access anyway.
Cheers,
--
Mark.
+----------------------------------------------------------+-----------+
| Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /|
| Mydas Solutions Ltd http://MydasSolutions.com |///// / //|
| +-----------------------------------+//// / ///|
| |We value your comments, which have |/// / ////|
| |been recorded and automatically |// / /////|
| |emailed back to us for our records.|/ ////////|
+----------------------+-----------------------------------+-----------+
sending to informix-list