Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

update stats on large tables

2 posts in General Discussion Last posting was on 2010-02-01 15:42:02.0Z
KS Posted on 2010-01-29 00:29:19.0Z
From: KS <id4kiran@gmail.com>
Newsgroups: sybase.public.ase.general
Subject: update stats on large tables
Date: Thu, 28 Jan 2010 16:29:19 -0800 (PST)
Organization: http://groups.google.com
Lines: 12
Message-ID: <b01ef3f6-0839-4df8-9005-98e84592dbad@b10g2000vbh.googlegroups.com>
NNTP-Posting-Host: 161.107.18.136
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1264724959 32491 127.0.0.1 (29 Jan 2010 00:29:19 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 29 Jan 2010 00:29:19 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: b10g2000vbh.googlegroups.com; posting-host=161.107.18.136; posting-account=K8C1DAoAAABT2J7yEDU2FOZd0w6uXq2w
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!novia!news-out.readnews.com!news-xxxfer.readnews.com!postnews.google.com!b10g2000vbh.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28916
Article PK: 78156

Hi,

We have many large tables 50milions+ records with at least 10+ data
partitions (round robin) on all of them. Because of lot of data
activities on dev/maint environments, we need to perform update index
stats quite often, which ends up in taking much of time. We have been
using update index stats for each of these tables, I was wondering
whether anyone has tried update stats/index stats with data partition
option?

Thanks,
Kiran


Sherlock, Kevin [TeamSybase] Posted on 2010-02-01 15:42:02.0Z
From: "Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com>
Newsgroups: sybase.public.ase.general
References: <b01ef3f6-0839-4df8-9005-98e84592dbad@b10g2000vbh.googlegroups.com>
Subject: Re: update stats on large tables
Lines: 19
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b66f64a$1@forums-1-dub>
Date: 1 Feb 2010 07:42:02 -0800
X-Trace: forums-1-dub 1265038922 10.22.241.152 (1 Feb 2010 07:42:02 -0800)
X-Original-Trace: 1 Feb 2010 07:42:02 -0800, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28926
Article PK: 78163

Have you tested using the "with consumers" option of update stats? What
version of ASE are you running?

"KS" <id4kiran@gmail.com> wrote in message
news:b01ef3f6-0839-4df8-9005-98e84592dbad@b10g2000vbh.googlegroups.com...
> Hi,
>
> We have many large tables 50milions+ records with at least 10+ data
> partitions (round robin) on all of them. Because of lot of data
> activities on dev/maint environments, we need to perform update index
> stats quite often, which ends up in taking much of time. We have been
> using update index stats for each of these tables, I was wondering
> whether anyone has tried update stats/index stats with data partition
> option?
>
> Thanks,
> Kiran