Index preference in Write intensive envt.

Hi,
Please let me know the index that needs to be created in write intensive
environments and why?
Thanks in advance
Manu
Manu,
For maximum performance, a unique clustered index (commonly a primary key)
on an incrementing value (commonly idenitity) is probably your best bet.
Eliminate any other indexes on the write intensive tables.
When a clustered index is used along with an incrementing value, the
organization of data pages is highly efficient as new records are inserted.
Fragmentation is minimized. Non-clustered indexes on the same data will
result in fragmentation requiring re-indexing to optimize performance.
From there, you can examine partitioning.
-- Bill
"manu" <manu@.discussions.microsoft.com> wrote in message
news:88E41056-2044-4DB0-BE5F-9892879E9CC6@.microsoft.com...
> Hi,
> Please let me know the index that needs to be created in write intensive
> environments and why?
> Thanks in advance
> Manu
|||On Mon, 8 Jan 2007 14:43:00 -0800, manu
<manu@.discussions.microsoft.com> wrote:

>Please let me know the index that needs to be created in write intensive
>environments and why?
When you say write-intensive, do you mean Insert or Update or both?
Answers can be quite different, depending.
J.
|||Actually it is more based on inserting new records. It would be better if u
can recommend for both the situations:-
1. Insert only
2. Insert and Update both
Thx. for ur reply..
Manu
"JXStern" wrote:

> On Mon, 8 Jan 2007 14:43:00 -0800, manu
> <manu@.discussions.microsoft.com> wrote:
>
> When you say write-intensive, do you mean Insert or Update or both?
> Answers can be quite different, depending.
> J.
>