Re: [SPAM] RE: Count(*) not doing a FTS??

Hey Jared...

  Maybe another example for your external tables article?

Tim

Wolfson Larry - lwolfs wrote:

>This is off the mark a little bit, but:
>
> I had a system that was getting killed by users doing Select
>count(*) all the time.
>When I asked them what they needed the information for they admitted to only
>needing approximate values for the row counts.
> Since we did full exports everyday I offered them an alternative of
>executing a UNIX script that would display what had been exported the last
>few weeks. This database only kept one export file on disk, but we had
>quite a few logs.
>
> They'd run the command and get back something like the list below
>only I included the correct date information for each line.
> And they were very happy because it was a hell of a lot faster for
>the larger tables and I was happy because they stopped clobbering the buffer
>pool.
>
> Larry
>
>MSI_STATS_LOG 11813 rows exported
>MSI_STATS_LOG 12202 rows exported
>MSI_STATS_LOG 12573 rows exported
>MSI_STATS_LOG 12927 rows exported
>
>
>PS you can also generate the report without generating the dmp file.
>
>

--
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe 
To search the archives - http://www.freelists.org/archives/oracle-l/