Re: sp_primarykey vs. unique clustered index

Path	csiph.com!x330-a1.tempe.blueboxinc.net!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!nx02.iad01.newshosting.com!newshosting.com!69.16.185.16.MISMATCH!npeer02.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
From	Antony <albion26.eve@gmail.com>
Newsgroups	comp.databases.sybase
Subject	Re: sp_primarykey vs. unique clustered index
Date	Wed, 26 Oct 2011 14:15:06 -0700 (PDT)
Organization	http://groups.google.com
Lines	2
Message-ID	<14191737.1148.1319663706441.JavaMail.geo-discussion-forums@prog16> (permalink)
References	<737f631e-dfea-4092-b4ad-3483e6836a75@v33g2000prm.googlegroups.com> <cb663cea-53e7-4745-a1b2-7658bba7f74c@h23g2000pra.googlegroups.com> <49d1017b-af52-41c7-b9f8-6dbbe39cb2a7@k35g2000yqh.googlegroups.com> <b924d4bf-e2d7-47dc-909a-af61a4ed9408@q35g2000prh.googlegroups.com> <2e43cffc-26ea-4f60-ab0e-d35d42582f8d@z26g2000yqh.googlegroups.com> <a71b938a-8a10-4fb4-9edd-4dcc723b130e@r25g2000prg.googlegroups.com> <0441ab89-31b7-4e38-94da-e2e00cec6527@y22g2000pri.googlegroups.com> <a1d20fba-bee6-426d-912f-60de41db5ce1@y8g2000yqf.googlegroups.com> <35748aeb-81c1-4050-8ac7-4bc2478b66e1@u24g2000pru.googlegroups.com> <0a11f6ac-93a1-47f9-9ce9-4d4c9630dcdd@x20g2000vbl.googlegroups.com> <9e0a8036-4a17-43c6-8fc6-d92404747c46@hv4g2000vbb.googlegroups.com>
Reply-To	comp.databases.sybase@googlegroups.com
NNTP-Posting-Host	210.48.49.225
Mime-Version	1.0
Content-Type	text/plain; charset=ISO-8859-1
X-Trace	posting.google.com 1319664646 690 127.0.0.1 (26 Oct 2011 21:30:46 GMT)
X-Complaints-To	groups-abuse@google.com
NNTP-Posting-Date	Wed, 26 Oct 2011 21:30:46 +0000 (UTC)
In-Reply-To	<9e0a8036-4a17-43c6-8fc6-d92404747c46@hv4g2000vbb.googlegroups.com>
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=210.48.49.225; posting-account=NnXtTwoAAAABgWhO-BeH3pCDvor0eHtW
User-Agent	G2/1.0
X-Google-Web-Client	true
Xref	x330-a1.tempe.blueboxinc.net comp.databases.sybase:544

Show key headers only | View raw

I think you need to give us the exact SQL you are using, as it doesn't seem obvious (at least to me) what you're really comparing.
Also, can you tell us when the DOL table was last reorg'd? In a DOL table, a clustered index isn't truly clustered, and the efficiency of a range query will decrease over time as rows get deleted/forwarded etc.

Back to comp.databases.sybase | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

sp_primarykey vs. unique clustered index 1dg618 <1dg618@gmail.com> - 2011-10-18 17:44 -0700
  Re: sp_primarykey vs. unique clustered index bret_halford@msn.com - 2011-10-19 08:53 -0700
  Re: sp_primarykey vs. unique clustered index Derek Asirvadem <derek.asirvadem@gmail.com> - 2011-10-19 12:01 -0700
    Re: sp_primarykey vs. unique clustered index 1dg618 <1dg618@gmail.com> - 2011-10-19 13:27 -0700
    Re: sp_primarykey vs. unique clustered index 1dg618 <1dg618@gmail.com> - 2011-10-19 14:09 -0700
      Re: sp_primarykey vs. unique clustered index bret_halford@msn.com - 2011-10-20 11:52 -0700
        Re: sp_primarykey vs. unique clustered index 1dg618 <1dg618@gmail.com> - 2011-10-20 15:59 -0700
          Re: sp_primarykey vs. unique clustered index Derek Asirvadem <derek.asirvadem@gmail.com> - 2011-10-20 20:38 -0700
            Re: sp_primarykey vs. unique clustered index Derek Asirvadem <derek.asirvadem@gmail.com> - 2011-10-21 00:07 -0700
              Re: sp_primarykey vs. unique clustered index 1dg618 <1dg618@gmail.com> - 2011-10-21 08:19 -0700
                Re: sp_primarykey vs. unique clustered index Derek Asirvadem <derek.asirvadem@gmail.com> - 2011-10-21 19:17 -0700
                Re: sp_primarykey vs. unique clustered index 1dg618 <1dg618@gmail.com> - 2011-10-22 16:44 -0700
                Re: sp_primarykey vs. unique clustered index 1dg618 <1dg618@gmail.com> - 2011-10-26 05:55 -0700
                Re: sp_primarykey vs. unique clustered index Antony <albion26.eve@gmail.com> - 2011-10-26 14:15 -0700
                Re: sp_primarykey vs. unique clustered index Derek Asirvadem <derek.asirvadem@gmail.com> - 2011-10-28 22:54 -0700
      Re: sp_primarykey vs. unique clustered index Derek Asirvadem <derek.asirvadem@gmail.com> - 2011-10-20 19:00 -0700

csiph-web