Fragmentation Strategy

Posted in 2004

Dirk Moolman — Fri, 28 May 2004 08:57:07 +0200 — source: Usenet: comp.databases.informix

This is a multi-part message in MIME format. ------_=_NextPart_001_01C44480.FDBFBD00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I work for a company that works with medical aid claims from members.=20 We currently use Solaris 9, and IDS 7.31FD3 (64bit) =20 =20 Our claims table is fragmented over 24 fragments (indexes are detached = in their own fragments) =20 =20 Question: will a change in fragmentation strategy - fragmenting on a = different column/s, help in increasing the performance, or is it = basically dependant on the activity / usage of each fragment, or the = number of fragments I have available, and not really the expression I = fragment on ? =20 Hope you understand the question! =20 TIA Dirk =20 =20 ________________________________ << ella for Spam Control >> has removed 1247 Spam messages and set aside = 593 Newsletters for me You can use it too - and it's FREE! www.ellaforspam.com=09 ------_=_NextPart_001_01C44480.FDBFBD00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <html> <head> <meta http-equiv=3DContent-Type content=3D"text/html; = charset=3Dus-ascii"> <meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)"> <style>  </style> </head> <body lang=3DEN-US link=3Dblue vlink=3Dpurple> <div class=3DSection1> I work for a company that works with medical aid claims from = members. We currently use Solaris 9, and IDS 7.31FD3 = (64bit)     Our claims table is fragmented over 24 fragments (indexes are = detached in their own fragments)     Question:  will a change in fragmentation strategy - = fragmenting on a different column/s, help in increasing the performance, or is it = basically dependant on the activity / usage of each fragment, or the number of = fragments I have available, and not really the expression I fragment on = ?   Hope you understand the question!   TIA Dirk     </div> </body> </html> <hr><table border=3D"1" cellpadding=3D"8" = cellspacing=3D"0" bgcolor=3D"#FFFF99" bordercolor=3D"#999999"><tr><td = align=3D"center">&lt&lt ella for Spam Control &gt&gt = has removed 1247 Spam messages and set aside = 593 Newsletters for me You can use it too - and it's = FREE!&nbsp&nbsp<a = href=3D"http://www.ellaforspam.com">www.ellaforspam.com</a></td></= tr></table>=00 ------_=_NextPart_001_01C44480.FDBFBD00-- sending to informix-list

Fragmentation Strategy

Related threads

Your privacy choices