RE: [askdba] Re: How to tune tables for inserts and Updates? (30 indexes on a transaction table?)

My initial, uninformed-about-your-application reaction is also to recoil from the notion that a reasonable design could result in a need for 30 indexes on a single transaction table.

Still, at only 10,000 transactions per day that is still a light load, so even if my wild guess that there is probably a better way to create a logical and physical schema to support your application requirements than that which leads you to be contemplating 30 indexes on a single transaction table is correct, you probably won't see too much trouble unless your load grows.

Regards,

mwf

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Chirag DBA Sent: Saturday, October 02, 2004 12:42 AM To: askdba_at_freelists.org; jcave_at_ddbcinc.com Cc: oracle-l_at_freelists.org
Subject: Re: [askdba] Re: How to tune tables for inserts and Updates?

Thanx lot for yr response friends.

Problem is one of my client is a Technical manager n he blasted when he saw 17 indexes of PK n FKs in my transaction table. He was worring n asked me that Have i included all the indexes. I said no, there are still some indexes are to be created on foreign keys and of course on some other tables on the basis of search criteria.

He was worring that it may happen that it will take 30 indexes, I said " Yes Sir..".

n he was out of control that this many indexes n all will degrade the performance.

Now How Should I tell him that U don worry abt it, and U can design yr DB for performance n I did so. But at least each different entity I should put in a different table. I told him that I can reduce if u want but the redundancy of data will be too high for that, which I can say at all a bad design.

Performance is an ongoing Process n U cant expect only DB design everytime to resolve performance issues. U need to see application performance, Bandwidth, n many other things as this is a website application for entire EMEA.

May be I m poor in communicating my views to him, but I m sure... Little Knowledge, always dangerous ( For others also...) ;-)

Thanx again guys...

• Chiku Chirag_at_HP.Com

On Fri, 1 Oct 2004 17:55:34 -0600, Justin Cave (DDBC) <jcave_at_ddbcinc.com> wrote:
> First off, 10,000 transactions per day works out to just 7 transactions
> per minute, which probably isn't going to put much of a load on the
> system unless you go with some absurd settings.

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l