Re: Data size impact on Performances

From: Michael Bialik <bialik_at_isdn.net.il>
Date: 15 Mar 2002 06:04:38 -0800
Message-ID: <969f8022.0203150604.2fd0e1c3@posting.google.com>

Hi.

Ron's advice is soun concerning data load. However as I understand you are concerned with query performance AFTER data load. IMHO:
1. For queries selecting the same number of rows you are supposed to get the same responce time (if you have proper indexes). 2. For queries selecting enlarged range of row you may expect some degradation (unless you introduce some new indexes).

HTH. Michael Received on Fri Mar 15 2002 - 08:04:38 CST

This message: [ Message body ]
Next message: Mike: "Oracle 8 client and Oracle 8i Personal Edition"
Previous message: Michael Bialik: "Re: Is there a better way than two "exists" and a union?"
In reply to: Ron van Zijl \(Prive\): "Re: Data size impact on Performances"
Next in thread: Kregen: "Re: Data size impact on Performances"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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