Very Computer

by **Rajes** » Wed, 16 Jul 2003 21:58:44

I was assuming that it is better to create Unique Clustered indexes on
Master tables and Unique Non-clustered indexes on Transaction tables. Is
this true in General for OLTP applications?

-Rp?

by **Anthony Mandi** » Wed, 16 Jul 2003 22:38:22

> I was assuming that it is better to create Unique Clustered indexes on
> Master tables and Unique Non-clustered indexes on Transaction tables. Is
> this true in General for OLTP applications?

Depends. What do you mean by master tables and transaction tables?
Every table can have one clustered index. You put it on the key(s)
as required by your data model.

-am ? 2003

Very Computer

Indexes

Indexes

Indexes