Re: when table was last changed?

From: Chuck Hamilton <chuckh_at_ix.netcom.com>
Date: 1995/12/27
Message-ID: <4bs00k$di8_at_cloner3.netcom.com>#1/1

glc <glc_at_neonramp.com> wrote:

>I create a LAST_CHANGE_DATE column in the table and and a trigger to plug SYSDATE
>into it on insert, update or delete.

Rather than adding a column to the table, why not just create a 2nd table with only two columns - table_name, and update_date? It'd be a lot faster to query the date when you need it.

--
Chuck Hamilton
chuckh_at_ix.netcom.com

If at first you don't succeed, sky-diving isn't for you.

Received on Wed Dec 27 1995 - 00:00:00 CET

This message: [ Message body ]
Next message: Raymond Bowers: "Help - Win32s Error on PO7 install for WFW 3.11????"
Previous message: jim cox: "Re: when table was last changed?"
Maybe in reply to: jim cox: "when table was last changed?"
In reply to glc: "Re: when table was last changed?"
Next in thread: Burton V. Peltier: "Re: ORA-03121 problem via (Intersolv) ODBC connection setup for NT and WIN95"
Reply: Edward Chopskie : "Re: when table was last changed?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message