Indexing

I have not worked much with indexing. I have some tables that are growing
fast and reporting out of them is becoming difficult. This is a venor
system, can adding indexes cause any problems? can indexes be removed? If
you know or some good readings on this topic I'd appreciate the reference.
ThanksGenerally, adding indexes will benefit data retrieval operations. It can
cause performance problems when inserting data, but the slight performance
penalty is probably worth it in most cases.
Yes indexes can be dropped.
Books Online within the SQL Server program group contains lots of good
information.
This is a pretty good site that contains lots of information:
http://www.sql-server-performance.com/
There are many other sites that you may find helpful. Here are a couple:
http://www.sqlserverfaq.com/
http://www.aspfaq.com/
Keith
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:719583D4-3F2B-402D-9FCD-E358DEA2C499@.microsoft.com...
> I have not worked much with indexing. I have some tables that are growing
> fast and reporting out of them is becoming difficult. This is a venor
> system, can adding indexes cause any problems? can indexes be removed? If
> you know or some good readings on this topic I'd appreciate the reference.
> Thanks|||Thanks!
"Keith Kratochvil" wrote:

> Generally, adding indexes will benefit data retrieval operations. It can
> cause performance problems when inserting data, but the slight performance
> penalty is probably worth it in most cases.
> Yes indexes can be dropped.
> Books Online within the SQL Server program group contains lots of good
> information.
> This is a pretty good site that contains lots of information:
> http://www.sql-server-performance.com/
> There are many other sites that you may find helpful. Here are a couple:
> http://www.sqlserverfaq.com/
> http://www.aspfaq.com/
> --
> Keith
>
> "Niles" <Niles@.discussions.microsoft.com> wrote in message
> news:719583D4-3F2B-402D-9FCD-E358DEA2C499@.microsoft.com...
>|||I don't seem to be able to index my Views although I have SQL server 2000
Enterprise Edition. Am I missing something?
Thanks,
"Keith Kratochvil" wrote:

> Generally, adding indexes will benefit data retrieval operations. It can
> cause performance problems when inserting data, but the slight performance
> penalty is probably worth it in most cases.
> Yes indexes can be dropped.
> Books Online within the SQL Server program group contains lots of good
> information.
> This is a pretty good site that contains lots of information:
> http://www.sql-server-performance.com/
> There are many other sites that you may find helpful. Here are a couple:
> http://www.sqlserverfaq.com/
> http://www.aspfaq.com/
> --
> Keith
>
> "Niles" <Niles@.discussions.microsoft.com> wrote in message
> news:719583D4-3F2B-402D-9FCD-E358DEA2C499@.microsoft.com...
>|||Did you read up on "Creating an Indexed View" within the indexed views index
item within Books Online?
mk:@.MSITStore:C:\Program%20Files\Microso
ft%20SQL%20Server\80\Tools\Books\cre
atedb.chm::/cm_8_des_06_9jnb.htm
Keith
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:DA782949-8A72-44E2-A512-55C948EB7249@.microsoft.com...[vbcol=seagreen]
> I don't seem to be able to index my Views although I have SQL server 2000
> Enterprise Edition. Am I missing something?
> Thanks,
>
> "Keith Kratochvil" wrote:
>
can[vbcol=seagreen]
performance[vbcol=seagreen]
couple:[vbcol=seagreen]
growing[vbcol=seagreen]
If[vbcol=seagreen]
reference.[vbcol=seagreen]|||There are some quite strict rules to be able to index views. Book Online
lists them all. However, in many cases it is not necessary to index
views. Often it is enough to just index the underlying tables.
IMO you should try to index the underlying tables first. If this does
not improve performance enough, then you can read up on indexed views
and consider them...
Hope this helps,
Gert-Jan
Niles wrote:[vbcol=seagreen]
> I don't seem to be able to index my Views although I have SQL server 2000
> Enterprise Edition. Am I missing something?
> Thanks,
> "Keith Kratochvil" wrote:
>|||Good suggestions!
Keith
"Gert-Jan Strik" <sorry@.toomuchspamalready.nl> wrote in message
news:41F95579.A8F5190B@.toomuchspamalready.nl...
> There are some quite strict rules to be able to index views. Book Online
> lists them all. However, in many cases it is not necessary to index
> views. Often it is enough to just index the underlying tables.
> IMO you should try to index the underlying tables first. If this does
> not improve performance enough, then you can read up on indexed views
> and consider them...
> Hope this helps,
> Gert-Jan