RE: Reorg to put columns in order

From: Kerber, Andrew W. <Andrew.Kerber_at_umb.com>
Date: Mon, 22 Oct 2007 09:27:41 -0500
Message-ID: <D40740337A3B524FA81DB598D2D7EBB30C39194E@x6009a.umb.corp.umb.com>

You are correct, they are wrong. Column order is really irrelevant. You can pull the needed columns up in any order you need it just by selecting by column name instead of select *. They are simply wrong.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Zanen van, J (Jacob) Sent: Monday, October 22, 2007 1:00 AM
To: oracle-l_at_freelists.org
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

Jack

This email, including any attachments, may be confidential or privileged, and is sent for the personal attention of the intended recipient. If you have received this email in error, please delete it immediately. The views expressed are not necessarily those of the Rabobank Group. The Group is not liable for the effects of any virus which may be contained in this email.

If this email contains marketing material and you do not wish to receive such material by email in future, please reply to this email and place the words "Remove My Details - Electronic Messages" in the Subject Header.

The Rabobank Group

Australia: 1800 025 484
New Zealand: 0800 500 933

NOTICE: This electronic mail message and any attached files are confidential. The information is exclusively for the use of the individual or entity intended as the recipient. If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited. If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you.

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Oct 22 2007 - 09:27:41 CDT