Re: How to select 1 record from 1M records fast ?
From: magicwand <magicwand_at_gmx.at>
Date: Thu, 15 Apr 2010 05:51:11 -0700 (PDT)
Message-ID: <4eb7aa49-b15e-44c1-9513-d0c2eaaea9c3_at_v14g2000yqb.googlegroups.com>
On 15 Apr., 14:14, Jia Lu <roka..._at_gmail.com> wrote:
> 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?
Date: Thu, 15 Apr 2010 05:51:11 -0700 (PDT)
Message-ID: <4eb7aa49-b15e-44c1-9513-d0c2eaaea9c3_at_v14g2000yqb.googlegroups.com>
On 15 Apr., 14:14, Jia Lu <roka..._at_gmail.com> wrote:
> 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?
Still too slow ?
First you were asking fo < 3 seconds, now 5-8 milliseconds (worst
case) is too slow ??
In this case you should talk to your Oracle seller about an In Memory
Database, there you will be in the nano seconds range ...
Received on Thu Apr 15 2010 - 07:51:11 CDT