Re: Need design suggestion , whether index organized table is good choice here

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 31 Jan 2022 15:26:51 -0500

On 1/31/22 05:39, Jonathan Lewis wrote:

1) Upgrade to 19c 2) 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.


Regards Jonathan 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
    -- //www.freelists.org/webpage/oracle-l

    Other related posts:

    1. Home
    2. oracle-l
    3. Archive
    4. 01-2022