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.

Reading an execution plan

2 posts in General Discussion Last posting was on 2010-07-27 16:23:35.0Z
Sybase Veteran Posted on 2010-07-27 16:00:38.0Z
Sender: 46c6.4c4f0110.1804289383@sybase.com
From: Sybase Veteran
Newsgroups: sybase.public.ase.general
Subject: Reading an execution plan
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4c4f02a6.46f7.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 27 Jul 2010 09:00:38 -0700
X-Trace: forums-1-dub 1280246438 10.22.241.41 (27 Jul 2010 09:00:38 -0700)
X-Original-Trace: 27 Jul 2010 09:00:38 -0700, 10.22.241.41
Lines: 12
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29415
Article PK: 78647

Where can I find any simple examples and documentation for
execution plans?

There seems to be a great amount of details for the simplest
query -

The execution plan details refer to lines numbers in
something?

Thanks,

-Paul


Sherlock, Kevin [TeamSybase] Posted on 2010-07-27 16:23:35.0Z
From: "Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com>
Newsgroups: sybase.public.ase.general
References: <4c4f02a6.46f7.1681692777@sybase.com>
Subject: Re: Reading an execution plan
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4c4f0807$1@forums-1-dub>
Date: 27 Jul 2010 09:23:35 -0700
X-Trace: forums-1-dub 1280247815 10.22.241.152 (27 Jul 2010 09:23:35 -0700)
X-Original-Trace: 27 Jul 2010 09:23:35 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29416
Article PK: 78648

what version of ASE?

Start here if ASE 15.x -
http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc00743.1502/html/queryprocessing/CACHHDHB.htm

or here if ASE 12.5.x -
http://infocenter.sybase.com/help/topic/com.sybase.dc20022_1251/html/monitoring/X85682.htm

<Sybase Veteran> wrote in message
news:4c4f02a6.46f7.1681692777@sybase.com...
> Where can I find any simple examples and documentation for
> execution plans?
>
> There seems to be a great amount of details for the simplest
> query -
>
> The execution plan details refer to lines numbers in
> something?
>
> Thanks,
>
> -Paul