Home -> Usenet -> comp.databases.oracle -> How to reorg a table?

How to reorg a table?

From: Steve Carrola <scarrola_at_mailsrvr.bussvc.wisc.edu>
Date: 1995/09/07
Message-ID: <42n4ho$15ec_at_news.doit.wisc.edu>#1/1 






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


Received on Thu Sep 07 1995 - 00:00:00 CEST












Original text of this message