Re: How to select 1 record from 1M records fast ?
From: Thomas Kellerer <OTPXDAJCSJVU_at_spammotel.com>
Date: Thu, 15 Apr 2010 14:29:44 +0200
Message-ID: <82of5oF4j3U1_at_mid.individual.net>
Jia Lu, 15.04.2010 14:14:
> On 4ζ15ζ₯, εεΎ9:02, magicwand<magicw..._at_gmx.at> wrote:
> Thanks for your answer.
> But if it still slow? is there any advanced method in 11gR2?
Date: Thu, 15 Apr 2010 14:29:44 +0200
Message-ID: <82of5oF4j3U1_at_mid.individual.net>
Jia Lu, 15.04.2010 14:14:
> On 4ζ15ζ₯, εεΎ9:02, magicwand<magicw..._at_gmx.at> wrote:
>> >> a) Thumb through the book starting from page 1 >> b) Look into the index and go to the page cited there
> Thanks for your answer.
> But if it still slow? is there any advanced method in 11gR2?
If the row can uniquely (!) be identified through an index, reading a single row from a table with 100 rows takes the same time as reading a single row from a table with 1,000,000 or 1,000,000,000 rows Received on Thu Apr 15 2010 - 07:29:44 CDT