Re: sp_primarykey vs. unique clustered index

From	Antony <albion26.eve@gmail.com>
Newsgroups	comp.databases.sybase
Subject	Re: sp_primarykey vs. unique clustered index
Date	2011-10-26 14:15 -0700
Organization	http://groups.google.com
Message-ID	<14191737.1148.1319663706441.JavaMail.geo-discussion-forums@prog16> (permalink)
References	(6 earlier) <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>

Show all headers | 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