Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Counting Records
"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 UKReceived on Mon Oct 13 2003 - 06:48:13 CDT