Re: Need design suggestion , whether index organized table is good choice here
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 31 Jan 2022 15:26:51 -0500
Message-ID: <56c61f29-92da-90ba-9f83-69296255b983_at_gmail.com>
Date: Mon, 31 Jan 2022 15:26:51 -0500
Message-ID: <56c61f29-92da-90ba-9f83-69296255b983_at_gmail.com>
On 1/31/22 05:39, Jonathan Lewis wrote:
1) Upgrade to 19c2) Hire someone to sign an NDA and get them to do a proper database design after a full briefing on requirements.
You are NOT asking for a "design suggestion", you're asking for yet another hack/stop-gap to keep your system limping along until it gets so unwieldy that it will be virtually impossible to do anything to fix it.
RegardsJonathan Lewis
Two points:
- It is usually I who writes tongue in cheek posts like this
one.
- What you are describing is the usual point of application
redesign. When the design gets too messed up to do anything that
makes sense, usually the hardware is thrown at the problem until
the redesign is done.
Regards
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com-- http://www.freelists.org/webpage/oracle-l Received on Mon Jan 31 2022 - 21:26:51 CET