DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: index fragmentation?

  1. 02-03-2001, 07:40 PM #1
    mybear
    mybear is offline Junior Member
    Join Date
    Jan 2001
    Posts
    72

    Exclamation segment in index tablespaces

    what if the segments in the index tablesapces have grown to 50, will that also cause fragmentation problem or this concept only applies to tables in the tablespaces.

    Reply With Quote Reply With Quote
  2. 02-04-2001, 11:23 AM #2
    mbaliga
    mbaliga is offline Member
    Join Date
    Jan 2001
    Posts
    126
    Hi,

    Segmentation applies both to tables and indexes. Depending on the growth rate you can resize the next extents.

    Baliga
    Reply With Quote Reply With Quote
  3. 02-04-2001, 04:35 PM #3
    mybear
    mybear is offline Junior Member
    Join Date
    Jan 2001
    Posts
    72
    so will exporting and importing of the tables(in data tablespace) in an attempt to defrag also defrag the indexes(in the index tablespace) at the same time?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width