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

  • From: Tim Johnston <oraclel@xxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 03 Sep 2004 10:20:26 -0400

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@xxxxxxxxxxxxx&subject=unsubscribe 
To search the archives - //www.freelists.org/archives/oracle-l/

Other related posts:

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