Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rhofing
Starting Member
15 Posts |
 Posted - 2001-11-05 : 15:46:01
|
| There are a number of tables that the DB users query frequently to generate reports. These tables are re-built every night using data from various views that pull data in from various tables.There is one common column througout these tables that I have indexed and this has helped. I feel though that performance can be improved even more with more targeted indexes. I have taken a number of the most common queries and analyzed them myself and I have come up with a number of indexing scenarios.I also decided to run them through the Index Analysis of Query Analyzer to see if it could suggest better indexes and/or confirm my choices.Whenever I do this I get the following message from some (most actually) of the queries:The query was unparseable for one of the following reasons:1. The user has selected the wrong database or text of the query selected for analysis is not parseable.2. The keyword GO was selected for tuning. I don't understand why this is happening. The queries work fine, they return data if I run them. The query types range from simple single table selects to multiple joins.Any help would be appreciated.Ric |
|
|
|
|
|
Index Analysis