RE: [askdba] Re: How to tune tables for inserts and Updates? (30 indexes on a transaction table?)
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 2 Oct 2004 10:23:19 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Chirag DBA
Sent: Saturday, October 02, 2004 12:42 AM
To: askdba@xxxxxxxxxxxxx; jcave@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxx
On Fri, 1 Oct 2004 17:55:34 -0600, Justin Cave (DDBC) <jcave@xxxxxxxxxxx>
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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » RE: [askdba] Re: How to tune tables for inserts and Updates? (30 indexes on a transaction table?)
