Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by bodhi108

  1. bodhi108

    Deploy vs Process

    I'm trying to understand deploy vs process in SSAS. My understanding was that you first build, then deploy, then process. When I went in that order (First Build and then Deploy), I got errors on the Deployment. But once I tried Process first and then Deploy I received no errors and was able...
  2. bodhi108

    Why is the query using the index even though the perecentage of unique

    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...
  3. bodhi108

    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!

Part and Inventory Search

Back
Top