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.

Global Index Vs Local Index

2 posts in General Discussion Last posting was on 2011-10-17 10:20:34.0Z
sybanva Posted on 2011-10-17 10:06:35.0Z
Sender: 35d1.4e9bfd8e.1804289383@sybase.com
From: sybanva
Newsgroups: sybase.public.ase.general
Subject: Global Index Vs Local Index
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e9bfe2b.35ec.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 17 Oct 2011 03:06:35 -0700
X-Trace: forums-1-dub 1318845995 10.22.241.41 (17 Oct 2011 03:06:35 -0700)
X-Original-Trace: 17 Oct 2011 03:06:35 -0700, 10.22.241.41
Lines: 4
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30603
Article PK: 73494

hi All,
Whats is global and local index in ASE 15.0?

Which is best for performance improvement and how?


Rob V Posted on 2011-10-17 10:20:34.0Z
From: Rob V <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
Organization: Sypron BV
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:7.0.1) Gecko/20110929 Thunderbird/7.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Global Index Vs Local Index
References: <4e9bfe2b.35ec.1681692777@sybase.com>
In-Reply-To: <4e9bfe2b.35ec.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: <4e9c0172$1@forums-1-dub>
Date: 17 Oct 2011 03:20:34 -0700
X-Trace: forums-1-dub 1318846834 10.22.241.152 (17 Oct 2011 03:20:34 -0700)
X-Original-Trace: 17 Oct 2011 03:20:34 -0700, vip152.sybase.com
Lines: 34
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30604
Article PK: 73495


On 17-Oct-2011 12:06, sybanva wrote:
> hi All,
> Whats is global and local index in ASE 15.0?
>
> Which is best for performance improvement and how?

This is related to semantic table partitioning. I suggest you do some
reading rather than me copying the documentation into a post...
"Best for performance" is a question that neve rhas a simple answer:
ever performance feature is a tradeoff between various aspects, so it
all depends what your workload, data, schema and requirements look like.

Start reading here:
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc32300.1550/html/sqlug/BHAHDJBA.htm

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