hmmm. must have read it wrong in the book. any idea how to get the 'estimated number of record returned?
>
> From: Hemant K Chitale <hkchital_at_singnet.com.sg>
> Date: 2003/09/26 Fri AM 10:44:40 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: Google's architecture -- was Re: paging and google.com
>
>
> Google certainly doesn't use an Oracle database. They just wouldn't get the
> performance
> that they achieve currently.
> See this link on Google's architecture
> : http://www.computer.org/micro/mi2003/m2022.pdf
>
> Hemant
>
> At 05:44 AM 26-09-03 -0800, you wrote:
> >Im in the middle of Kytes new tuning book. He states that google uses a
> >query similiar to this to return web pages in their search function:
> >
> >select /*+ FIRST_ROWS */ b.*
> >from ( select a.*, a.rownum
> > from (your query here) a
> > where rownum < <<pick max number of rows you want in a batch >>)
> >where rownum > <<will start with 1 and be max + 1 for each 'page' >>
> >
> >
> >If they are using oracle to do this, how do they get the estimated number
> >of total results? Is it from 'cardinality'? Do you know which data
> >dictionary that comes from? explain plan is costly so they cant be using that.
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.net
> >--
> >Author: <rgaffuri_at_cox.net
> > INET: rgaffuri_at_cox.net
> >
> >Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> >San Diego, California -- Mailing list and web hosting services
> >---------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
> Hemant K Chitale
> Oracle 9i Database Administrator Certified Professional
> My personal web site is : http://hkchital.tripod.com
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Hemant K Chitale
> INET: hkchital_at_singnet.com.sg
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <rgaffuri_at_cox.net
INET: rgaffuri_at_cox.net
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Sep 26 2003 - 09:59:40 CDT
