Table Fragmentation
Hi,
thanks for your suggestions, I was run the update statistics but the problem
continues.
Somebody know some tools for view table distributions on disks?
Thanks again..
Paola
Quoting "Jonathan Le...." <jleffler@us.ibm.com>:
>
>
>
>
> Yes -- RTFM.
>
> ALTER TABLE ADD (newcolumn INTEGER DEFAULT 0 NOT NULL), DROP CONSTRAINT
> pk_constraint, ADD CONSTRAINT PRIMARY KEY (oldpkcol1, oldpkcol2, newcolumn)> CONSTRAINT pk_constraint;
>
> You might need to do some surgery on the zeroes in the new column in the
> example. If you don't provide a default and do have data in the database,
> you won't be able to do it in one statement because the new column will be
> assigned nulls in the absence of a default, and you can't create a primary
> key on a column containing nulls.
>
> --
> Jonathan Leffler (jleffler@us.ibm.com)
> STSM, Informix Database Engineering, IBM Data Management Solutions
> 4100 Bohannon Drive, Menlo Park, CA 94025
> Tel: +1 650-926-6921 Tie-Line: 630-6921
> "I don't suffer from insanity; I enjoy every minute of it!"
>
>
> |---------+---------------------------->
> | | "Hamid HABZI " |
> | | <HHABZI@bmcebank.|
> | | co.ma> |
> | | Sent by: |
> | | forum.subscriber@|
> | | iiug.org |
> | | |
> | | |
> | | 03/03/2003 07:33 |
> | | AM |
> | | |
> |---------+---------------------------->
>
>
>-----------------------------------------------------------------------------
----------------------------------------------------------------|
> |
> |
> | To: ids@iiug.org
> |
> | cc:
> |
> | Subject: Primary key [553]
> |
> |
> |
>
>
>-----------------------------------------------------------------------------
----------------------------------------------------------------|
>
>
>
>
> Hi,
> Is it possible to add a column to the primary key whithout unloading,
> droping, Re-creating then loading the table?.
> Tanks for helping.
> Regards.
>
>
>
>
>
>
-------------------------------------------------
This mail sent through IMP: http://mail.info.unlp.edu.ar/