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.

Leading column of a index

3 posts in General Discussion Last posting was on 2011-06-30 19:03:20.0Z
Satsun Posted on 2011-06-30 10:44:32.0Z
Sender: e6c.4e0c5315.1804289383@sybase.com
From: satsun
Newsgroups: sybase.public.ase.general
Subject: Leading column of a index
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e0c5390.e82.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 30 Jun 2011 03:44:32 -0700
X-Trace: forums-1-dub 1309430672 10.22.241.41 (30 Jun 2011 03:44:32 -0700)
X-Original-Trace: 30 Jun 2011 03:44:32 -0700, 10.22.241.41
Lines: 7
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30296
Article PK: 72476

Hi All,

Can someone please explianme what is meant by "Leading
column of an index"

Thanks,
Satsun


Rob V [ Sybase ] Posted on 2011-06-30 11:36:22.0Z
From: "Rob V [ Sybase ]" <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
Organization: Sypron BV / TeamSybase / Sybase
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110616 Lightning/1.0b2 Thunderbird/3.1.11
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Leading column of a index
References: <4e0c5390.e82.1681692777@sybase.com>
In-Reply-To: <4e0c5390.e82.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: <4e0c5fb6$1@forums-1-dub>
Date: 30 Jun 2011 04:36:22 -0700
X-Trace: forums-1-dub 1309433782 10.22.241.152 (30 Jun 2011 04:36:22 -0700)
X-Original-Trace: 30 Jun 2011 04:36:22 -0700, vip152.sybase.com
Lines: 35
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30297
Article PK: 72475


On 30-Jun-2011 12:44, satsun wrote:
> Hi All,
>
> Can someone please explianme what is meant by "Leading
> column of an index"
>
> Thanks,
> Satsun

It is the first column in the index.
An index can be created on multiple columns, for example:

create index ix1 on mytable(a, b, c)

Here, 'a' is the leading index column. 'b' and 'c' are the non-leading
index column.

HTH,

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

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

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


Satsun Posted on 2011-06-30 19:03:20.0Z
Sender: 23d6.4e0cbf4f.1804289383@sybase.com
From: Satsun
Newsgroups: sybase.public.ase.general
Subject: Re: Leading column of a index
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e0cc878.2572.1681692777@sybase.com>
References: <4e0c5fb6$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 30 Jun 2011 12:03:20 -0700
X-Trace: forums-1-dub 1309460600 10.22.241.41 (30 Jun 2011 12:03:20 -0700)
X-Original-Trace: 30 Jun 2011 12:03:20 -0700, 10.22.241.41
Lines: 2
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30298
Article PK: 72480

Thanks Rob..,