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.

query optimization

5 posts in General Discussion Last posting was on 2006-05-30 11:33:12.0Z
Megan Alstrapa Posted on 2006-01-07 11:01:37.0Z
Sender: 2ff2.43bf9d16.1804289383@sybase.com
From: Megan Alstrapa
Newsgroups: ianywhere.public.general
Subject: query optimization
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <43bf9f91.3005.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 7 Jan 2006 03:01:37 -0800
X-Trace: forums-1-dub 1136631697 10.22.241.41 (7 Jan 2006 03:01:37 -0800)
X-Original-Trace: 7 Jan 2006 03:01:37 -0800, 10.22.241.41
Lines: 6
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5105
Article PK: 17511

Can someone please help me find detailed information on how
query optimization is implemented in sql anywhere version 8
or newer?
All i can find is info on the SQL Anywhere 5.x Cost-Based
Query Optimizer and i was wandering if things have changed
since then.


Martha Moreno Posted on 2006-05-29 19:40:16.0Z
From: "Martha Moreno" <mmoreno@ciudadceleste.com>
Newsgroups: ianywhere.public.general
References: <43bf9f91.3005.1681692777@sybase.com>
Subject: Re: query optimization
Lines: 11
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 200.24.207.155
X-Original-NNTP-Posting-Host: 200.24.207.155
Message-ID: <447b4e20@forums-1-dub>
Date: 29 May 2006 12:40:16 -0700
X-Trace: forums-1-dub 1148931616 200.24.207.155 (29 May 2006 12:40:16 -0700)
X-Original-Trace: 29 May 2006 12:40:16 -0700, 200.24.207.155
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5404
Article PK: 1453

<Megan Alstrapa> escribió en el mensaje
news:43bf9f91.3005.1681692777@sybase.com...

> Can someone please help me find detailed information on how
> query optimization is implemented in sql anywhere version 8
> or newer?
> All i can find is info on the SQL Anywhere 5.x Cost-Based
> Query Optimizer and i was wandering if things have changed
> since then.


Greg Fenton Posted on 2006-05-30 01:50:33.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Thunderbird 1.5.0.2 (Windows/20060308)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: query optimization
References: <43bf9f91.3005.1681692777@sybase.com> <447b4e20@forums-1-dub>
In-Reply-To: <447b4e20@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: cpe00096b10fe8a-cm000f212f9e50.cpe.net.cable.rogers.com
Message-ID: <447ba464$1@forums-2-dub>
X-Original-Trace: 29 May 2006 18:48:20 -0700, cpe00096b10fe8a-cm000f212f9e50.cpe.net.cable.rogers.com
Lines: 30
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 29 May 2006 18:48:21 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 29 May 2006 18:50:33 -0700
X-Trace: forums-1-dub 1148953833 10.22.108.75 (29 May 2006 18:50:33 -0700)
X-Original-Trace: 29 May 2006 18:50:33 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5405
Article PK: 1455


Martha Moreno wrote:
>> Can someone please help me find detailed information on how
>> query optimization is implemented in sql anywhere version 8
>> or newer?
>> All i can find is info on the SQL Anywhere 5.x Cost-Based
>> Query Optimizer and i was wandering if things have changed
>> since then.

Yes, things have changed *drastically* since v5, especially with the
release of v8 where the engine's architecture was drastically revamped.

The query optimizer is still cost-based. But there are now much more
efficient algorithms used and new tools available to help you analyze
your application's performance.

For example, there is the Graphical Plan in ISQL, Request Level Logging
(and analysis routines), the Procedure Profiler for stored procedures,
and others.

Can you describe what it is in your application that you are looking to
analyze?

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


Breck Carter [Team iAnywhere] Posted on 2006-05-30 11:33:12.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: query optimization
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <23bo721snjg0co1hu7cneud9jftohu2n9m@4ax.com>
References: <43bf9f91.3005.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
X-Original-Trace: 30 May 2006 04:30:57 -0700, bcarter.sentex.ca
Lines: 23
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 30 May 2006 04:30:58 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 30 May 2006 04:33:12 -0700
X-Trace: forums-1-dub 1148988792 10.22.108.75 (30 May 2006 04:33:12 -0700)
X-Original-Trace: 30 May 2006 04:33:12 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5406
Article PK: 1456

The latest version...
http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0902/en/html/index.html

Version 8.0.0...
http://manuals.sybase.com/onlinebooks/group-sas/awg0800e/dbugen8/@ebt-link;nh=1;pt=3167;uf=0?target=0;window=new;showtoc=true;book=dbugen8;;__prev_hit__=3167;DwebQuery=query+optimization

Breck

On 7 Jan 2006 03:01:37 -0800, Megan Alstrapa wrote:

>Can someone please help me find detailed information on how
>query optimization is implemented in sql anywhere version 8
>or newer?
>All i can find is info on the SQL Anywhere 5.x Cost-Based
>Query Optimizer and i was wandering if things have changed
>since then.

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com


"Chris Keating(iAnywhere Solutions)" <NoSpamPlease_k_e_a_t_i_n_g Posted on 2006-01-07 15:42:59.0Z
From: "Chris Keating(iAnywhere Solutions)" <NoSpamPlease_k_e_a_t_i_n_g@i_A_n_y_w_h_e_r_e.com>
Organization: iAnywhere Solutions
User-Agent: Thunderbird 1.5 (Windows/20051201)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: query optimization
References: <43bf9f91.3005.1681692777@sybase.com>
In-Reply-To: <43bf9f91.3005.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: 10.18.242.22
Message-ID: <43bfdec5$1@forums-2-dub>
X-Original-Trace: 7 Jan 2006 07:31:17 -0800, 10.18.242.22
Lines: 25
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 7 Jan 2006 07:31:20 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 7 Jan 2006 07:42:59 -0800
X-Trace: forums-1-dub 1136648579 10.22.108.75 (7 Jan 2006 07:42:59 -0800)
X-Original-Trace: 7 Jan 2006 07:42:59 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5106
Article PK: 8669

There has been extensive changes in optimization since SA5. Have you
looked at the product documentation?
--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

*****************************************************************************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

*****************************************************************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

*****************************************************************************