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.

Positioning by key

2 posts in General Discussion Last posting was on 2012-07-07 18:07:24.0Z
Raj Posted on 2012-07-07 11:01:10.0Z
Sender: 2e8a.4ff81641.1804289383@sybase.com
From: Raj
Newsgroups: sybase.public.ase.general
Subject: Positioning by key
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4ff816f6.2eac.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 7 Jul 2012 04:01:10 -0700
X-Trace: forums-1-dub 1341658870 172.20.134.41 (7 Jul 2012 04:01:10 -0700)
X-Original-Trace: 7 Jul 2012 04:01:10 -0700, 172.20.134.41
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31222
Article PK: 74111

Hi,

When does query plan show "positioning by key" or
"positioning at index start".
what do they mean ?
What changes should we make to change the plan to
"positioning by key" from "positioning at index start" ?
(Sybase 15.0.3ESD#1)

Thanks in advance,
Raj


Rob V Posted on 2012-07-07 18:07:24.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:13.0) Gecko/20120614 Thunderbird/13.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Positioning by key
References: <4ff816f6.2eac.1681692777@sybase.com>
In-Reply-To: <4ff816f6.2eac.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: <4ff87adc@forums-1-dub>
Date: 7 Jul 2012 11:07:24 -0700
X-Trace: forums-1-dub 1341684444 172.20.134.152 (7 Jul 2012 11:07:24 -0700)
X-Original-Trace: 7 Jul 2012 11:07:24 -0700, vip152.sybase.com
Lines: 37
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31223
Article PK: 74113


On 07-Jul-2012 13:01, Raj wrote:
> Hi,
>
> When does query plan show "positioning by key" or
> "positioning at index start".
> what do they mean ?
> What changes should we make to change the plan to
> "positioning by key" from "positioning at index start" ?
> (Sybase 15.0.3ESD#1)
>
> Thanks in advance,
> Raj
>

Already answered your question in sybase.public.ase.performance+tuning.
Please do not cross-post.

--
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
-----------------------------------------------------------------