| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: what is wrong with this idea ...
If you are using 8i+ consider using materl. views. They are wonderful and
make maintenance of denormalized objects much less of a chore. I am oh so
happy with them. There are some limitations but still.
-----Original Message-----
Sent: Wednesday, August 14, 2002 12:34 PM
To: Multiple recipients of list ORACLE-L
Dennis,
Yes, at this moment I'm debating whether to go with one combined string or several separate fields. I'm not thrilled by any of the options, but the former really doesn't look good to me. What I'm trying to avoid is every transaction having to run a query against a large (tens of millions rows) child table in order to count the statuses.
Another - totally different - option would be to
create
an aggregate (I think someone did mention that), but I
haven't had much sucess designing an appropriate
aggregate yet
Gene
--- DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> wrote:
Is your tradeoff between
> four separate columns
> or a single column with concatenated values?
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: gurelei_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Paula_Stankus_at_doh.state.fl.us Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Aug 14 2002 - 12:13:44 CDT
 |
 |