Indexing large fragmented table

I have a table with a row size of 104 bytes containing approximately 800 million rows. The table is fragmented across 51 dbspaces where each fragment uses upto a maximum of 450,000 of the allocated 524,197 pages. I would like to place some indexes on the table. Since there is little space available in each fragment, would my only option be to create a detached index in an available dbspace or is there some other way to fragment the index across other available dbspaces? Thanks, Tony

Hi, I think if you have other available dbspaces then you can create the index using btree to fragment it across those spaces. But be sure that the space is big enough since the indexes fill up the space faster than the actual data. Leo --- "Demeis, Tony" <Tony.Demeis@moh.gov.on.ca> wrote: > I have a table with a row size of 104 bytes > containing approximately 800 > million rows. The table is fragmented across 51 > dbspaces where each > fragment uses upto a maximum of 450,000 of the > allocated 524,197 pages. I > would like to place some indexes on the table. > Since there is little space > available in each fragment, would my only option be > to create a detached > index in an available dbspace or is there some other > way to fragment the > index across other available dbspaces? > > Thanks, > Tony > ===== Leona Ankrah Systems Administrator Ghana Telecommunications Company Ltd. Tel: +233202002425 Fax: +23321241613 __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com

Table that size, I would question first whether you need an index - if you need row level access then of course you do. You can detach indices 8 ways to sunday, fragmenting them across other empty dbspaces. Hannah Metzger did a lovely article on that at one point - might be on developer zone, not sure. I think someone posted a link to it in this group within the past 18 months. cheers j. ----- Original Message ----- From: "Demeis, Tony" <Tony.Demeis@moh.gov.on.ca> To: <ids@iiug.org> Sent: Wednesday, January 22, 2003 8:19 AM Subject: Indexing large fragmented table [74] > I have a table with a row size of 104 bytes containing approximately 800 > million rows. The table is fragmented across 51 dbspaces where each > fragment uses upto a maximum of 450,000 of the allocated 524,197 pages. I > would like to place some indexes on the table. Since there is little space > available in each fragment, would my only option be to create a detached > index in an available dbspace or is there some other way to fragment the > index across other available dbspaces? > > Thanks, > Tony > >