Re: Oracle v/s SqlServer ...

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 3 Jun 2004 14:11:15 +0100
Message-ID: <7765c89704060306116bc02de4@mail.gmail.com>

The answer is yes and sort of.

IOT
===
Rather surprisngly to anyone from an oracle background *most* tables in an MSSQL database will be stored in a specific index order. The concept to look for in books online is Clustered Index. The index doesn't have to be the primary key for the table, and indeed it may well make sense for it not to be. There is no overflow segment either. How do you use them - simply create a clustered index on the table.

Partitioning

---

What you get are partitioned views, that is to say you effectively get a table for each partition and then a union all view of all partitions. The partition key must be NOT NULL - makes sense - and mssql applies a CHECK constraint to the partitioning key. The table must have a primary key which includes the partition key. As of MSSQL2k you can do this across different databases - then it gets called Distributed Partition Views if you have any sense of Federated Databases if you are in marketing :)

Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

• Original Message ----- From: Harsh Agrawal <harsha_at_amdocs.com> Date: Thu, 3 Jun 2004 14:05:54 +0300 Subject: Oracle v/s SqlServer ... To: oracle-l_at_freelists.org

Hi Xperts,

Below is the question related to Oracle & SqlServer.

Do we have "Index Organized Tables" and "Partioned Tables" in SqlServer 2k ?

How do we use them in SqlServer2k ?

---

Thanks and Regards,

Harsh Agrawal

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Thu Jun 03 2004 - 08:08:14 CDT