trafodion-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Qifan Chen <qifan.c...@esgyn.com>
Subject Re: Raise error when UPDATE STATS is done on a really big table?
Date Fri, 22 Jan 2016 17:11:55 GMT
Hi Dave,

Sounds like a good idea, at least for now.

We may also need to define how big is too big, maybe through a CQD.

--Qifan

On Fri, Jan 22, 2016 at 10:37 AM, Dave Birdsall <dave.birdsall@esgyn.com>
wrote:

> Hi,
>
>
>
> Just want to make you aware of the following JIRA:
> https://issues.apache.org/jira/browse/TRAFODION-1775.
>
>
>
> In that JIRA, I propose making it an error to do UPDATE STATISTICS on a
> really big table without using sampling. The reason being that it can take
> a very long time in this case and is usually not intended. I will provide a
> syntax that can override the error.
>
>
>
> If you think this is a bad idea, or you think of better approaches, please
> comment in the JIRA. If you think it is a great idea, you can make that
> comment too, but I will consider silence as consent.
>
>
>
> Thanks,
>
>
>
> Dave
>



-- 
Regards, --Qifan

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message