Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
http://www-306.ibm.com/software/data/informix/pubs/library/ids_94.html
scroll down and select the "Performance Guide, Version 9.4"
in this manual, go to chapter 9, "Fragmentation Guidelines".
fragmenting by expression takes some prep work but once set up it really
simplifies massive deletes.
we use it to speed our partial database refreshes.
good luck,
Norma Jean
Tam OShanter wrote:
>Yes. It does sound quite interesting.
>Can you provide more information, or at least a hint on where to start
>looking for practical examples?
>
>Thanks Friends,
>
>Tam.
>> ...detach the fragment...
>>
>[quoted text clipped - 41 lines]
>>> Informix-list@iiug.org
>>> http://www.iiug.org/mailman/listinfo/informix-list
--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums.aspx/informix/200609/1
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.