January 10, 2018 at 11:33 am
You ever use DTA much? Here is what it output as index recommendations.
January 10, 2018 at 12:13 pm
Jackie Lowery - Wednesday, January 10, 2018 11:33 AMYou ever use DTA much? Here is what it output as index recommendations.
Nope. Its recommendations aren't always good,
January 10, 2018 at 12:35 pm
Lynn Pettis - Wednesday, January 10, 2018 12:13 PMJackie Lowery - Wednesday, January 10, 2018 11:33 AMYou ever use DTA much? Here is what it output as index recommendations.Nope. Its recommendations aren't always good,
And are occasionally quite bad.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 11, 2018 at 2:17 am
-- Add column Docref to index ix_sent_01
-- in addition to eliminating the key lookup, this will refresh statistics, which look stale
-- Another new index for you
CREATE INDEX ix_Stuff ON Trade (TP_PartID) INCLUDE (TP_Name)
-- And a couple of query changes
SELECT DISTINCT For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
January 11, 2018 at 11:06 am
ChrisM,
We're going to move to the new version of our EDI software. The engineers I've been working with are telling me the indexes we've been looking at are already implemented in the newest version, so you were definitely taking me down the right path. Also, they've been testing your version of the query and i think they're going to implement it in the next update.
Thanks for all the help .
Viewing 5 posts - 31 through 34 (of 34 total)
You must be logged in to reply to this topic. Login to reply