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.

binary datatype vs integer

2 posts in Windows NT Last posting was on 2000-06-23 21:56:09.0Z
Shahin Sakopanah Posted on 2000-06-21 21:12:29.0Z
Reply-To: "Shahin Sakopanah" <ssakopanah@hotmail.com>
From: "Shahin Sakopanah" <ssakopanah@hotmail.com>
Subject: binary datatype vs integer
Date: Wed, 21 Jun 2000 16:12:29 -0500
Lines: 7
Organization: Bridge
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <ciiBcX82$GA.279@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: gkbkup2.bridge.com 167.76.159.20
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1980
Article PK: 1089422

Which datatype as PK would result in better performance?


Thanks
Shahin


Sanjay Kumar Posted on 2000-06-23 21:56:09.0Z
Message-ID: <3953DCF9.F0D5A6F3@nbci.com>
Date: Fri, 23 Jun 2000 14:56:09 -0700
From: Sanjay Kumar <sanjayk@nbci.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.72 [en]C-CCK-MCD (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: binary datatype vs integer
References: <ciiBcX82$GA.279@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 4
NNTP-Posting-Host: 209-113.snap.com 206.132.209.113
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1974
Article PK: 1089415

Integer gives better performance...

Shahin Sakopanah wrote:

> Which datatype as PK would result in better performance?
>
> Thanks
> Shahin