http://forum.lowyat.net/ Thu, 22 Oct 2026 13:14:00 +0800 FeedCreator 1.7.2 http://forum.lowyat.net/topic/649454 Hope that some LYN DB Expert can help me to determine which is better in term of performance<br />Which to look at when determining the performance? IO, Cost or cardinality? Hash join or nested loop is better?<br /><br />New Index : Higher cost , Lower cardinality , High IO Cost (3 index keys. NOT UNIQUE)<br />Old Index : Lower cost , Higher cardinality , Lower IO Cost (2 index keys. NOT UNIQUE)<br />SQL Statment : Same for both. Just add a field into the index.<br />Table size approximately : Few Million records <br /><br /><img src='http://img364.imageshack.us/img364/9605/cardinalityvscostpj4.jpg' border='0' alt='user posted image' /><br /><br /> shockwave Codemasters Tue, 11 Mar 2008 11:56:18 +0800 http://forum.lowyat.net/topic/640603 I&#39;m wandering if any of you have the reading material for Oracle Certified Associates &amp; MCAD certification?<br />Mind to share some material, tips, websites, ebooks or anything related?<br />Roughly how much would it cost?<br /> shockwave Codemasters Wed, 27 Feb 2008 18:38:31 +0800