Index aginst table having lot of inserts

Hi ,
i have a question reg index on my table which is having somany inserts. is
that good design to have index on table table which has lot of inserts?
Thanks
BhaskarLike many design considerations, it depends. Virtually all tables should
have a primary key and corresponding index. Additional indexes are often
appropriate to speed up query performance. Of course, the benefits of these
indexes need to be weighted against the associated costs of slower inserts
and space requirements. Since data is usually read more times than written,
the improved data retrieval performance often justifies the write
performance penalty. Storage is inexpensive nowadays.
Hope this helps.
Dan Guzman
SQL Server MVP
"Bhaskar" <Bhaskar@.discussions.microsoft.com> wrote in message
news:D91C16BA-D172-4929-81AB-E92C17F0F8FE@.microsoft.com...
> Hi ,
> i have a question reg index on my table which is having somany inserts. is
> that good design to have index on table table which has lot of inserts?
> Thanks
> Bhaskar|||When you say that the table has a lot of inserts, are you speaking of
transactional inserts or bulk inserting?
http://www.microsoft.com/technet/pr...br />
4fec.asp
If you are concerned about fragmentation of indexes as a result of inserts:
http://www.microsoft.com/technet/pr...n/ss2kidbp.mspx
"Bhaskar" <Bhaskar@.discussions.microsoft.com> wrote in message
news:D91C16BA-D172-4929-81AB-E92C17F0F8FE@.microsoft.com...
> Hi ,
> i have a question reg index on my table which is having somany inserts. is
> that good design to have index on table table which has lot of inserts?
> Thanks
> Bhaskar