Oracle Scratchpad

May 31, 2012

Clustered Indexes

Filed under: SQL Server — Jonathan Lewis @ 11:24 am BST May 31,2012

… which, for those in the know, means something to do with SQL Server. (The closest physical feature in Oracle  is the index-organized table, the closest sounding name for an Oracle feature is the index cluster – which, just to add to the confusion, must have a specific index that is called the cluster index).

Red Gate has arranged for an online debate between an Oracle specialist (me) and a SQL Server specialist (Grant Fritchey) to talk about the strengths and weaknesses of the two mechanisms, discuss why Oracle users seem to be biased towards one implementation and SQL Server users towards the other, and then see where the conversation takes us. This will be followed by a Q&A session.

If this sounds interesting – and I think it’s a great idea, you can learn an awful lot more from a discussion than you can by listening to monologue – you need to sign up early. The event will be held on 7th June at 16:00 BST.

Update: Now that the discussion is over, you can listen to the recording at this URL.

7 Comments »

  1. Jonathan, I have been working with Oracle for about 16 years and just this year joined a project working with SQL Server for the first time… it’s been a “learning experience” for sure. Having attended a couple of your presentations in New York the last few years, I am very excited to see how this debate goes. Sounds like fun! Cheers!

    Comment by Reinhard Hillefeld — April 30, 2012 @ 3:34 pm BST Apr 30,2012 | Reply

    • Reinhard,

      I’ve written a couple of notes on this blog about SQL Server before now (pointing out, amongst other things, a couple of details where it does better than Oracle), and I’ve also written a couple of notes for SimpleTalk – an offshoot website for Redgate. If you want to track them down, just follow the SQL Server category from the top of this article.

      Comment by Jonathan Lewis — April 30, 2012 @ 8:23 pm BST Apr 30,2012 | Reply

      • Thank you, these look great! I did not know you had dabbled in SQL Server. These will be a good pre-read for the debate. Thanks again…

        Comment by Reinhard Hillefeld — April 30, 2012 @ 8:44 pm BST Apr 30,2012 | Reply

  2. This looks interesting. My understanding of why clustered indexes were originally used on SQueaLy SwERVER was that it enforced striping data across disks. Not sure if that was true then, or even now, but I look forward to a clarification of that.

    Comment by twoknightsthenight — April 30, 2012 @ 4:22 pm BST Apr 30,2012 | Reply

  3. [...] Jonathan Lewis is going to have a live debate on Clustered Indexes with respect to the Oracle and SQL Server. [...]

    Pingback by Log Buffer #270, A Carnival of the Vanities for DBAs | The Pythian Blog — May 4, 2012 @ 7:01 am BST May 4,2012 | Reply

  4. Reblogged this on lava kafle kathmandu nepal.

    Comment by lkafle — June 1, 2012 @ 3:45 am BST Jun 1,2012 | Reply

  5. [...] the success of the last Oracle/SQL Server discussion, James Murtagh of Redgate has arranged another online discussion – this time about the [...]

    Pingback by Temporary Tables « Oracle Scratchpad — October 17, 2012 @ 9:32 am BST Oct 17,2012 | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The Rubric Theme. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 4,011 other followers