Re: Thoughts on comments

From: <rajugaru.vij_at_gmail.com>
Date: Fri, 22 Mar 2013 04:37:26 +0000
Message-ID: 748472858-1363927044-cardhu_decombobulator_blackberry.rim.net-1765580807-_at_b28.c12.bise7.blackberry>



Noob question,
If I describe the object, will these comments be visible?

------Original Message------
From: z b
To: raju raju
Cc: oracle-l_at_freelists.org
Subject: Re: Thoughts on comments
Sent: Mar 22, 2013 10:02 AM

> Will that increase dictionary space?

Obviously.

> Will that have any performance issues?

Not sure. It's metadata, so tools like Toad and SQLDeveloper can see it. Don't think it would impact normal queries.

> How to use comments? I mean to add and retrieve. Would be helpful

The idea is the database will be "self-documenting". This is what ER Diagrams are for, not necessarily metadata adds like "comments".

On Fri, Mar 22, 2013 at 12:29 AM, <rajugaru.vij_at_gmail.com> wrote:
> 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
>
>

Sent on my BlackBerry®--
http://www.freelists.org/webpage/oracle-l Received on Fri Mar 22 2013 - 05:37:26 CET

Original text of this message