Re: How to reorg a table?

In article <42n4ho$15ec_at_news.doit.wisc.edu> scarrola_at_mailsrvr.bussvc.wisc.edu (Steve Carrola) writes:
>From: scarrola_at_mailsrvr.bussvc.wisc.edu (Steve Carrola)
>Subject: How to reorg a table?
>Date: 7 Sep 1995 15:53:28 GMT
 

>In databases like DB2, you can reorganize a table so that the physical
>file is placed in sorted order by the primary key. This usually increases
>performance. Does the export/import of a table take care of this?
 

>If so, is there another way to do this without an export/import? with
>the table on-line?
 

>Also, is there a query sample that someone has to tell you how
>disorganized the table is?
 

>Thanks
 

>Steve Carrola Univ. of Wisconsin-Madison
>scarrola_at_mailsrvr.bussvc.wisc.edu Business Services

If you are looking for a means to reorganize Oracle tablespaces you should consider PLATINUM TSreorg. TSreorg improves the efficiency of large Oracle databases by restructuring objects that have become disorganized due to heavy use. The product, which is designed for large mission-critical databases, reorganizes data without using the time-consuming, error-prone procedure of rebuilding the entire database structure. After TSreorg corrects the problems of database organization (e.g., fragmentation, poor row ordering, over-allocation of storage space), system performance increases and user response time decreases significantly.

For more information contact PLATINUM technology, inc. at: 1-800-442-6861 -OR- 708/620-5000

Cheers,
Craig S. Mullins Received on Thu Sep 07 1995 - 00:00:00 CEST