Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Reorg to put columns in order

Re: Reorg to put columns in order

From: Mike Haddon <>
Date: Mon, 22 Oct 2007 23:40:50 -0500
Message-ID: <>

In my experience, you are at odds with the developers because they only have confidence in one way. I would recommend that you provide the statistics of both methods of getting the data. If you can show that reorganizing the table buys them nothing then they cannot deny it. Once they see that getting the columns in the order they wish even if the reorg is not performed, is just as efficient, then it is on their plate to show the benefit.

Show them that the reorg, while time consuming and resource intensive, is unnecessary, then let them justify the cost.

Just my .02

> ------------------------------------------------------------------------
> *From:*
> [] *On Behalf Of *Zanen van, J
> (Jacob)
> *Sent:* Monday, October 22, 2007 2:00 AM
> *To:*
> *Subject:* Reorg to put columns in order
> Hi All,
> I'm having a bit of an issue with our designers/developers for our
> so called "datawarehouse"
> Columns are added to tables every so often based on requirements
> from the business. They however insist on doing a reorg to get the
> columns in a certain order so when they pull them up in BO the
> columns show up in an order that makes sense to them. I have
> raised my doubts about this procedure as it takes a 2 second job
> and squeezes it in a 7 hour job.
> I can see from a chained/migrated row point of view that there
> might be a valid reason for it but since they have always done it
> this I see no way for me to find out how bad this is going to be.
> I suspect for most of these tables it won't make much difference
> as they are not filled with data for historical records AFAIK.
> My solution for them was to create a view on top of the table but
> they rejected the idea and insist this is the way to go.
> Anybody have any insight for me.
> Thnx

Received on Mon Oct 22 2007 - 23:40:50 CDT

Original text of this message