Is the data in a SQL Server 2000 table still available for external applications, during editing or adding indexes via the Enterprise Manager?
Is the data in a SQL Server 2000 table still available for external applications, during editing or adding indexes via the Enterprise Manager?
View Answer
| May 14 2008 3:24 AM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2000, Enterprise Manager, Indexes
DB2 indexes and Crystal Reports
Is it possible to access DB2 (V5R1) indexes from the Visual Linking Expert screen in Crystal Reports(8) and if so how?
Answer Question
| Apr 22 2008 10:31 AM GMT
| asked by
AJ52
DB2, Indexes, Crystal Reports 8
Why is the query using the index even though the perecentage of unique values is 52%?
I have a table with no primary key and a non-clustered composite index of two columns. When I look at the number of distinct values (selectivity ratio), the table has a ratio of 52% unique values. I thought an index should be at least 90% unique in order for it to be used. Yet when I run the...
View Answer
| Mar 3 2008 5:09 AM GMT
| asked by
Abbi
Indexes, SQL performance, SQL
execution plan is same even though it takes 10 times longer to run
I have a query that accesses a table with a non-clustered index. When I drop the index and run the query, it takes 1.25 minutes to run. With the index, it takes 2 seconds to run. Yet, the execution plan is the same with or without the index. How can that be?Thank you!
View Answer
| Mar 3 2008 5:07 AM GMT
| asked by
Abbi
Execution Plan, Indexes, Performance/Tuning
Stored Procedure for dropping indexes
I would like a stored procedure that will take as input the name of a table. Whatthe procedure would do is drop all indexes on that table excpet any index that ends with U1 or P1, and save the information on the ones it drops.Then I would like another strored procedure that takes a table name as...
View Answer
| Feb 28 2008 4:04 PM GMT
| asked by
Dangagne
Indexes, DROP, Restore
