Re: Thoughts on comments

From: <rajugaru.vij_at_gmail.com>
Date: Fri, 22 Mar 2013 04:29:52 +0000
Message-ID: 597779737-1363926589-cardhu_decombobulator_blackberry.rim.net-1212390751-_at_b28.c12.bise7.blackberry>

Hi,
Nice, I never saw any comment on any of the objects or columns in my database.

Questions:

Will that increase dictionary space?
Will that have any performance issues?
How to use comments? I mean to add and retrieve. Would be helpful

Thanks
Sent on my BlackBerry®

-----Original Message-----

From: z b <zimsbait_at_gmail.com>
Sender: oracle-l-bounce_at_freelists.org Date: Fri, 22 Mar 2013 00:25:21
To: <oracle-l_at_freelists.org>
Reply-To: zimsbait_at_gmail.com
Subject: Thoughts on comments

Listers,

Just wanted to get a general opinion on using comments in the database. For example COMMENT ON COLUMN table.column "No comment".

Does anyone do this as a regular best practice? I would prefer to see this abstraction in a data model, maybe not pushed to the database layer, especially since not all RDBMS engines have "comment" functionality.

The thought is we should do this for every column, every table, every oracle db. This ends up being several million comments added to the our various instances.
--

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

--

http://www.freelists.org/webpage/oracle-l Received on Fri Mar 22 2013 - 05:29:52 CET