Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: performance database oracle

Re: performance database oracle

From: hitman <dsagner_at_post.t-com.hr>
Date: 6 Jul 2006 02:34:28 -0700
Message-ID: <1152178468.016592.237630@75g2000cwc.googlegroups.com>

B.Coenen_at_gmail.com wrote:
> Which case will be better for the performance to find a record?

Avoid one-to-one relationships i.e. if you have some attributes related to a key, then put them in one single table (case 1). Never mind 40 or 140 of them.

It seems that in Case 2 you are trying to make your own composite index by which the search in the second table will be performed. Why not let Oracle do what it does very good?

About the performance: you probably intend to do search by "personid", so the speed will mostly depend on selectivity of that column (among few other things).

DS Received on Thu Jul 06 2006 - 04:34:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US