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.

TemporalTables in ASE 15.5

4 posts in General Discussion Last posting was on 2011-08-23 13:30:08.0Z
RGS Posted on 2011-08-17 15:51:21.0Z
Sender: 6b1d.4e4be23c.1804289383@sybase.com
From: RGS
Newsgroups: sybase.public.ase.general
Subject: TemporalTables in ASE 15.5
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e4be379.6b4f.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 17 Aug 2011 08:51:21 -0700
X-Trace: forums-1-dub 1313596281 10.22.241.41 (17 Aug 2011 08:51:21 -0700)
X-Original-Trace: 17 Aug 2011 08:51:21 -0700, 10.22.241.41
Lines: 20
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30467
Article PK: 72646

I am using ASE 15.5

I have a stored procedure like that:

create table #records
create index i1 on #records
create index i2 on #records
insert into #records select ....
select * from t1,t2,#records where (joins)

The question is: Is necesary change the order of the
sentences "create index" and put them AFTER of the INSERT
command?

What about the statistics on the temporal tables in ASE
15.5? I know that in this version ASE really know the true
value of the total records of this kind of tables to solve
querys very well...

Thanks!


Michael Peppler [Team Sybase] Posted on 2011-08-18 04:53:46.0Z
From: "Michael Peppler [Team Sybase]" <mpeppler@peppler.org>
Organization: Peppler Consulting SARL
Subject: Re: TemporalTables in ASE 15.5
User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity.)
Message-ID: <pan.2011.08.18.04.53.40.440179@peppler.org>
Newsgroups: sybase.public.ase.general
References: <4e4be379.6b4f.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 17 Aug 2011 21:53:46 -0700
X-Trace: forums-1-dub 1313643226 10.22.241.152 (17 Aug 2011 21:53:46 -0700)
X-Original-Trace: 17 Aug 2011 21:53:46 -0700, vip152.sybase.com
Lines: 32
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30470
Article PK: 72647


On Wed, 17 Aug 2011 08:51:21 -0700, RGS wrote:

> I am using ASE 15.5
>
> I have a stored procedure like that:
>
> create table #records
> create index i1 on #records
> create index i2 on #records
> insert into #records select ....
> select * from t1,t2,#records where (joins)
>
> The question is: Is necesary change the order of the sentences "create
> index" and put them AFTER of the INSERT command?

In general it is better to create the indexes after the tables have been
populated.


>
> What about the statistics on the temporal tables in ASE 15.5? I know that
> in this version ASE really know the true value of the total records of
> this kind of tables to solve querys very well...

The latest versions of 15.0.3 and 15.5 have temp table auto stats, a
feature that will compute statistics on the fly. However, I think (though
I'm not sure!) that this will only get done inside stored procs. I guess
Rob or someone who has looked at this feature in more details can correct
me if necessary :-)

Michael


Rob V Posted on 2011-08-18 08:54:37.0Z
From: Rob V <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
Organization: Sypron BV
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:6.0) Gecko/20110812 Thunderbird/6.0
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: TemporalTables in ASE 15.5
References: <4e4be379.6b4f.1681692777@sybase.com> <pan.2011.08.18.04.53.40.440179@peppler.org>
In-Reply-To: <pan.2011.08.18.04.53.40.440179@peppler.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4e4cd34d$1@forums-1-dub>
Date: 18 Aug 2011 01:54:37 -0700
X-Trace: forums-1-dub 1313657677 10.22.241.152 (18 Aug 2011 01:54:37 -0700)
X-Original-Trace: 18 Aug 2011 01:54:37 -0700, vip152.sybase.com
Lines: 56
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30471
Article PK: 72650


On 18-Aug-2011 06:53, Michael Peppler [Team Sybase] wrote:
> On Wed, 17 Aug 2011 08:51:21 -0700, RGS wrote:
>
>> I am using ASE 15.5
>>
>> I have a stored procedure like that:
>>
>> create table #records
>> create index i1 on #records
>> create index i2 on #records
>> insert into #records select ....
>> select * from t1,t2,#records where (joins)
>>
>> The question is: Is necesary change the order of the sentences "create
>> index" and put them AFTER of the INSERT command?
> In general it is better to create the indexes after the tables have been
> populated.
>
>
>> What about the statistics on the temporal tables in ASE 15.5? I know that
>> in this version ASE really know the true value of the total records of
>> this kind of tables to solve querys very well...
> The latest versions of 15.0.3 and 15.5 have temp table auto stats, a
> feature that will compute statistics on the fly. However, I think (though
> I'm not sure!) that this will only get done inside stored procs. I guess
> Rob or someone who has looked at this feature in more details can correct
> me if necessary :-)
>
> Michael
>

The 'auto temptable statistics' feature would indeed play a role here.
Since there are too many sides to it to discuss here, please check my
Techwave 2010 presentation (available at
http://www.sypron.nl/downloads.html).

--

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks& Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------


RGS Posted on 2011-08-23 13:30:08.0Z
Sender: 5bfe.4e53aa7c.1804289383@sybase.com
From: RGS
Newsgroups: sybase.public.ase.general
Subject: Re: TemporalTables in ASE 15.5
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e53ab60.5c8e.1681692777@sybase.com>
References: <4e4cd34d$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 23 Aug 2011 06:30:08 -0700
X-Trace: forums-1-dub 1314106208 10.22.241.41 (23 Aug 2011 06:30:08 -0700)
X-Original-Trace: 23 Aug 2011 06:30:08 -0700, 10.22.241.41
Lines: 64
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30491
Article PK: 72669

Thank you very much

> On 18-Aug-2011 06:53, Michael Peppler [Team Sybase] wrote:
> > On Wed, 17 Aug 2011 08:51:21 -0700, RGS wrote:
> >
> >> I am using ASE 15.5
> >>
> >> I have a stored procedure like that:
> >>
> >> create table #records
> >> create index i1 on #records
> >> create index i2 on #records
> >> insert into #records select ....
> >> select * from t1,t2,#records where (joins)
> >>
> >> The question is: Is necesary change the order of the
> sentences "create >> index" and put them AFTER of the
> > INSERT command? In general it is better to create the
> > indexes after the tables have been populated.
> >
> >
> >> What about the statistics on the temporal tables in ASE
> 15.5? I know that >> in this version ASE really know the
> true value of the total records of >> this kind of tables
> > to solve querys very well... The latest versions of
> > 15.0.3 and 15.5 have temp table auto stats, a feature
> that will compute statistics on the fly. However, I think
> > (though I'm not sure!) that this will only get done
> > inside stored procs. I guess Rob or someone who has
> > looked at this feature in more details can correct me if
> necessary :-) >
> > Michael
> >
>
> The 'auto temptable statistics' feature would indeed play
> a role here. Since there are too many sides to it to
> discuss here, please check my Techwave 2010 presentation
> (available at http://www.sypron.nl/downloads.html).
>
> --
>
> HTH,
>
> Rob V.
> ----------------------------------------------------------
> ------- Rob Verschoor
>
> Certified Sybase Professional DBA for ASE
> 15.0/12.5/12.0/11.5/11.0 and Replication Server
> 15.0.1/12.5 // TeamSybase
>
> Author of Sybase books (order online at
> www.sypron.nl/shop): "Tips, Tricks& Recipes for Sybase
> ASE" (ASE 15 edition) "The Complete Sybase ASE Quick
> Reference Guide" "The Complete Sybase Replication Server
> Quick Reference Guide"
>
> rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter:
> @rob_verschoor Sypron B.V., The Netherlands | Chamber of
> Commerce 27138666
> ----------------------------------------------------------
> -------
>