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.

select * from partition

3 posts in Product Futures Discussion Last posting was on 2003-10-09 21:00:40.0Z
Jose Morales Posted on 2003-09-04 16:03:41.0Z
From: "Jose Morales" <jmorales@cibernetica.net>
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: select * from partition
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 207.50.140.51
X-Original-NNTP-Posting-Host: 207.50.140.51
Message-ID: <3f57625d@forums-1-dub>
Date: 4 Sep 2003 09:03:41 -0700
X-Trace: forums-1-dub 1062691421 207.50.140.51 (4 Sep 2003 09:03:41 -0700)
X-Original-Trace: 4 Sep 2003 09:03:41 -0700, 207.50.140.51
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1384
Article PK: 95612

Hi,

I am sure that this feature is a must for big tables using partitions. If
ASE handle partitions and I am able to load data via bcp to every partition
then is sane thinking that I will want to query data stored in a specific
partition. Suppose that I put into partition1 data about sales on month1, in
partition 2 data about sales on month 2 and so on. I think that ASE must
have the sintax in T-SQL in the form select * from bigtable:partion1 i.e. in
order to made happy to customer that need features like this.

Regards,

Jose Morales


putnamr Posted on 2003-09-05 20:25:27.0Z
Sender: d33.3f58f178.1804289383@sybase.com
From: putnamr@river.it.gvsu.edu
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Re: select * from partition
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f58f18b.d36.846930886@sybase.com>
References: <3f57625d@forums-1-dub>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 5 Sep 2003 13:26:51 -0700, 10.22.241.42
Lines: 38
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 5 Sep 2003 13:23:06 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 5 Sep 2003 13:25:27 -0700
X-Trace: forums-1-dub 1062793527 10.22.108.75 (5 Sep 2003 13:25:27 -0700)
X-Original-Trace: 5 Sep 2003 13:25:27 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1386
Article PK: 95622

Hello,

My gatherings from techwave are that Sybase is working on a
solution for range based partitioning of tables. I would
suspect that they would incorporate into this the ability to
select out of a partition naturally (systematically) because
of the range that the partition is based on. I do hope they
do consider your suggestion also, that is, having the
ability to specify that the select only run against one of
partitions. Because yes it would be nice to run something
like this:

SELECT *
FROM TABLE (PARTITION 1/PARTITION 2/etc)

Where PARTITION n represents the partition(s) to be
accessed.

Thanks,
Ryan Putnam

> Hi,
>
> I am sure that this feature is a must for big tables using
> partitions. If ASE handle partitions and I am able to load
> data via bcp to every partition then is sane thinking that
> I will want to query data stored in a specific partition.
> Suppose that I put into partition1 data about sales on
> month1, in partition 2 data about sales on month 2 and so
> on. I think that ASE must have the sintax in T-SQL in the
> form select * from bigtable:partion1 i.e. in order to made
> happy to customer that need features like this.
>
> Regards,
>
> Jose Morales
>
>


BSB Posted on 2003-10-09 21:00:40.0Z
From: "BSB" <ss>
Newsgroups: sybase.public.ase.product_futures_discussion
References: <3f57625d@forums-1-dub> <3f58f18b.d36.846930886@sybase.com>
Subject: Re: select * from partition
Lines: 44
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: 192.216.135.8
Message-ID: <3f85cd45$1@forums-2-dub>
X-Original-Trace: 9 Oct 2003 14:04:05 -0700, 192.216.135.8
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 9 Oct 2003 13:54:59 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 9 Oct 2003 14:00:40 -0700
X-Trace: forums-1-dub 1065733240 10.22.108.75 (9 Oct 2003 14:00:40 -0700)
X-Original-Trace: 9 Oct 2003 14:00:40 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1410
Article PK: 96416

This is something Oracle has had for a long time. I agree - it is a must for
working with large tables.

<putnamr@river.it.gvsu.edu> wrote in message
news:3f58f18b.d36.846930886@sybase.com...
> Hello,
>
> My gatherings from techwave are that Sybase is working on a
> solution for range based partitioning of tables. I would
> suspect that they would incorporate into this the ability to
> select out of a partition naturally (systematically) because
> of the range that the partition is based on. I do hope they
> do consider your suggestion also, that is, having the
> ability to specify that the select only run against one of
> partitions. Because yes it would be nice to run something
> like this:
>
> SELECT *
> FROM TABLE (PARTITION 1/PARTITION 2/etc)
>
> Where PARTITION n represents the partition(s) to be
> accessed.
>
> Thanks,
> Ryan Putnam
>
> > Hi,
> >
> > I am sure that this feature is a must for big tables using
> > partitions. If ASE handle partitions and I am able to load
> > data via bcp to every partition then is sane thinking that
> > I will want to query data stored in a specific partition.
> > Suppose that I put into partition1 data about sales on
> > month1, in partition 2 data about sales on month 2 and so
> > on. I think that ASE must have the sintax in T-SQL in the
> > form select * from bigtable:partion1 i.e. in order to made
> > happy to customer that need features like this.
> >
> > Regards,
> >
> > Jose Morales
> >
> >