Raj, Thanks, however adding the attribute to this table is the correct thing to do - it's a historical table to supply "show me something as at x date/time for the particular record". Basically when originally created (years before my time) someone assumed that a record would never be updated more often than once per second - they were wrong. So, whilst the timestamp doesn't create uniqueness we will add a version attribute (which already exists and is maintained on the primary table).
Regards,
Mark.
"Jamadagni,
Rajendra" To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
<Rajendra.Jamadagn cc:
[EMAIL PROTECTED]> Subject: RE: Re: Opinions of
high-volume DDL and data population
Sent by:
[EMAIL PROTECTED]
com
17/06/2003 01:29
Please respond to
ORACLE-L
... now from an entirely different angle ...
Mark,
It just _might_ be better if you create a separate table to store the pk
from your students table and the total_attendance column. Why? Not only
this column adding will be complicated, but maintaining this column in the
same table would be very mutating-table-problem-friendly.
If you make it in a separate table (with PK from the original table), you
can just create a trigger in the main table to maintain that value as well.
Not to mention that this will be less of a problem in the future.
Raj
--------------------------------------------------------------------------------
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art ! (See attached
file: ESPN_Disclaimer.txt)
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Privileged/Confidential information may be contained in this message.
If you are not the addressee indicated in this message
(or responsible for delivery of the message to such person),
you may not copy or deliver this message to anyone.
In such case, you should destroy this message and kindly notify the sender
by reply e-mail or by telephone on (61 3) 9612-6999.
Please advise immediately if you or your employer does not consent to
Internet e-mail for messages of this kind.
Opinions, conclusions and other information in this message
that do not relate to the official business of
Transurban City Link Ltd
shall be understood as neither given nor endorsed by it.
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
ESPN_Disclaimer.txt
Description: Binary data
