Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Counting Records

Re: Counting Records

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 13 Oct 2003 12:48:13 +0100
Message-ID: <3f8a90fd$0$247$ed9e5944@reading.news.pipex.net>


"Billy Verreynne" <vslabs_at_onwe.co.za> wrote in message news:1a75df45.0310130311.5a1079bd_at_posting.google.com...
> And when you start talking aggregation and the like, materialised
> views could be a better solution.
>
> Unless you want to show off the speed of your database with a parlour
> trick of doing a SELECT count(*) on a VLT of 77+ million rows in less
> than 7 seconds. ;-)

We are going to have to get you to do 2 concurrent updates on that table one of these days Billy. :(

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Mon Oct 13 2003 - 06:48:13 CDT

Original text of this message

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