Re: Small remark - Was: Backup Oracle ? Online Redo Log.

From: Keith Boulton <kboulton_at_ntlworld.com>
Date: Tue, 15 Jan 2002 20:52:55 -0000
Message-ID: <LA018.28926$_x4.4009998@news2-win.server.ntlworld.com>

Dusan Bolek <pagesflames_at_usa.net> wrote in message news:1e8276d6.0201150723.5c030607_at_posting.google.com...
> There were more funny moments, for example they wants to store all 1TB
> of data in one table which has no partitions and two indexes - date
> (that's reasonable) and system_identifier (which should be
> VARCHAR2(256) !!!). They've also told me that this can't be changed,
> because it's hard coded in product. I have no doubts about performance
> of this system.

It sound like the sort of thing that is used to store object instances, with an object identifier and a blob or set of fields to hold the data belonging to the object. Given that, one table with an index on indentifier should perform more than adequately.

Of course, you can't back it up and there doesn't seem much point in using a relational database, but apart from that... Received on Tue Jan 15 2002 - 14:52:55 CST