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.

Karthik M

3 posts in General Discussion Last posting was on 2013-03-22 07:06:52.0Z
Bushy Plan Posted on 2013-03-21 09:47:39.0Z
Sender: 6913.514ad64a.1804289383@sybase.com
From: Bushy Plan
Newsgroups: sybase.public.ase.general
Subject: Karthik M
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <514ad73b.6948.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 21 Mar 2013 01:47:39 -0800
X-Trace: forums-1-dub 1363859259 172.20.134.41 (21 Mar 2013 01:47:39 -0800)
X-Original-Trace: 21 Mar 2013 01:47:39 -0800, 172.20.134.41
Lines: 13
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31734
Article PK: 1308540

Hi All,

I have read about "Bushy Plan" in an article called
"Optimizer - Join Order". My questions are as below

1) Does System-R derived in Sybase?
2) Does sybase support "Bushy Plan" while joining tables?
3) Does sybase apply left deep tree or right deep tree by
default?
4) If sybase supports "Bushy Plan", how to force this plan
to optimizer to use this?
5) I need some sample queries which will use "Bushy Plan"
method to resolve the join order?


Rob V Posted on 2013-03-21 10:36:42.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:17.0) Gecko/20130307 Thunderbird/17.0.4
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Karthik M
References: <514ad73b.6948.1681692777@sybase.com>
In-Reply-To: <514ad73b.6948.1681692777@sybase.com>
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: <514ae2ba$1@forums-1-dub>
Date: 21 Mar 2013 02:36:42 -0800
X-Trace: forums-1-dub 1363862202 172.20.134.152 (21 Mar 2013 02:36:42 -0800)
X-Original-Trace: 21 Mar 2013 02:36:42 -0800, vip152.sybase.com
Lines: 58
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31735
Article PK: 1308542


On 21-Mar-2013 10:47, Bushy Plan wrote:
> Hi All,
>
> I have read about "Bushy Plan" in an article called
> "Optimizer - Join Order". My questions are as below
>
> 1) Does System-R derived in Sybase?
> 2) Does sybase support "Bushy Plan" while joining tables?
> 3) Does sybase apply left deep tree or right deep tree by
> default?
> 4) If sybase supports "Bushy Plan", how to force this plan
> to optimizer to use this?
> 5) I need some sample queries which will use "Bushy Plan"
> method to resolve the join order?
>

System-R has nothing to do with Sybase.

Query plan in Sybase ASE are executed left-deep. A query plan is not
"bushy". The ASE 15 query optimizer can use "bushy trees" (a particular
type of algorithm) as part of its process to *generate* an optimal query
plan.
The only feature you can find in ASE related to this is the optimizer
criterium "bushy_space_search" which controls whther bushy-style
algorithms are used during query plan generation. Note that this is
advanced ASE query optimizer material, so you should perhaps not try to
use it unless you first learn a lot more about how ASE's query optimzer
and query execution.
See the ASE Performance & Tuning manuals at http://sybooks.sybase.com
for more information.


******
Please note that these newgroups will go offline soon.
See
http://nntp-archive.sybase.com/nntp-archive/action/article/%3C513726e2%40forums-1-dub%3E
for more details about the new location of the forums
******


--
HTH,

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

Certified Professional DBA for Sybase ASE, IQ, Replication Server

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase IQ Quick Reference Guide"
"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
-----------------------------------------------------------------


karthik Posted on 2013-03-22 07:06:52.0Z
Sender: 6913.514ad64a.1804289383@sybase.com
From: Karthik
Newsgroups: sybase.public.ase.general
Subject: Bushy Plan
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <514c030c.4753.1681692777@sybase.com>
References: <514ae2ba$1@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 21 Mar 2013 23:06:52 -0800
X-Trace: forums-1-dub 1363936012 172.20.134.41 (21 Mar 2013 23:06:52 -0800)
X-Original-Trace: 21 Mar 2013 23:06:52 -0800, 172.20.134.41
Lines: 71
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31736
Article PK: 1308565

is it advisable to use "Bushy plan" nor not? In SQL Server,
it is not generally advisble to use. How about Sybase?

how about right deep?

> On 21-Mar-2013 10:47, Bushy Plan wrote:
> > Hi All,
> >
> > I have read about "Bushy Plan" in an article called
> > "Optimizer - Join Order". My questions are as below
> >
> > 1) Does System-R derived in Sybase?
> > 2) Does sybase support "Bushy Plan" while joining
> > tables? 3) Does sybase apply left deep tree or right
> > deep tree by default?
> > 4) If sybase supports "Bushy Plan", how to force this
> > plan to optimizer to use this?
> > 5) I need some sample queries which will use "Bushy
> > Plan" method to resolve the join order?
> >
>
> System-R has nothing to do with Sybase.
>
> Query plan in Sybase ASE are executed left-deep. A query
> plan is not "bushy". The ASE 15 query optimizer can use
> "bushy trees" (a particular type of algorithm) as part of
> its process to *generate* an optimal query plan.
> The only feature you can find in ASE related to this is
> the optimizer criterium "bushy_space_search" which
> controls whther bushy-style algorithms are used during
> query plan generation. Note that this is advanced ASE
> query optimizer material, so you should perhaps not try to
> use it unless you first learn a lot more about how ASE's
> query optimzer and query execution.
> See the ASE Performance & Tuning manuals at
> http://sybooks.sybase.com for more information.
>
>
> ******
> Please note that these newgroups will go offline soon.
> See
>
http://nntp-archive.sybase.com/nntp-archive/action/article/<513726e2@forums-1-dub>
> for more details about the new location of the forums
> ******
>
>
> --
> HTH,
>
> Rob V.
> ----------------------------------------------------------
> ------- Rob Verschoor
>
> Certified Professional DBA for Sybase ASE, IQ, Replication
> Server
>
> Author of Sybase books (order online at
> www.sypron.nl/shop): "Tips, Tricks & Recipes for Sybase
> ASE" "The Complete Sybase IQ Quick Reference Guide"
> "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
> ----------------------------------------------------------
> -------