hmmm. must have read it wrong in the book. any idea how to get the 'estimated number of record returned? > > From: Hemant K Chitale <[EMAIL PROTECTED]> > Date: 2003/09/26 Fri AM 10:44:40 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > 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: <[EMAIL PROTECTED] > > INET: [EMAIL PROTECTED] > > > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
