No announcements
Found 1548959 threads
-
2 VotesOptimize a Query
Once you are there with a query that runs slow, you need to analyse and understand the query plan which can be an art in itself.Answered | 2 Replies | 1946 Views | Created by Prashanth.P - Wednesday, June 6, 2012 3:06 PM | Last reply by Erland Sommarskog - Wednesday, June 6, 2012 3:20 PM
-
1 Votes
Query optimization
It is helpful if you post the query and related information.Answered | 4 Replies | 2341 Views | Created by RoyalM - Thursday, July 12, 2012 12:14 PM | Last reply by Kalman Toth - Thursday, July 19, 2012 7:07 AM -
0 Votes
query optimization
index on dbo.Fact columns Key, Source and Currency will help optimize these queries.Answered | 6 Replies | 1561 Views | Created by Ashwin AC - Friday, February 1, 2013 11:26 AM | Last reply by Kostya Khomyakov - Tuesday, February 5, 2013 2:09 PM -
3 Votes
Optimizing Query
The query you posted isn't a valid query, so we can't say what indexes might help you.Answered | 4 Replies | 931 Views | Created by Lakshmi Sundari - Tuesday, December 11, 2018 3:46 PM | Last reply by TiborK - Wednesday, December 12, 2018 7:40 AM -
0 Votes
Query Optimization
My base query was taking 9 seconds duration, with 8 seconds of CPU.Answered | 3 Replies | 5099 Views | Created by gk1393 - Thursday, May 19, 2011 7:50 PM | Last reply by JRStern - Thursday, May 19, 2011 9:01 PM -
0 Votes
how to optimize this query
The difference in performance is sqlserver cannot optimize the query for top n row since it is paramaterised which means unknown number of rows which will be ...Answered | 5 Replies | 2065 Views | Created by harsha_pal - Tuesday, October 23, 2012 12:50 PM | Last reply by Suri Nagarajan - Wednesday, November 7, 2012 5:17 PM -
1 Votes
Need help optimizing my query
I also looked at my DVDs and I could not find anything called col1, product_something, col3, and col4.Answered | 6 Replies | 3166 Views | Created by mr JT - Thursday, August 11, 2011 2:13 PM | Last reply by --CELKO-- - Thursday, August 11, 2011 3:53 PM -
2 Votes
Query optimization
There are several kinds of coupling, which are ranked from worse to best: 1) Content 2) Common 3) Control 4) ...Answered | 3 Replies | 1133 Views | Created by Kshitiz Kothari - Friday, February 8, 2013 2:17 PM | Last reply by --CELKO-- - Friday, February 8, 2013 6:18 PM -
1 Votes
query optimization tools?
My BizCardAnswered | 3 Replies | 5171 Views | Created by rbhatup - Friday, November 25, 2011 12:25 PM | Last reply by SQLPuzzleSolver - Monday, October 12, 2015 6:37 PM -
0 Votes
Query Optimization
My conlusion is because I had the similar issue a while ago on our UAT region and upon investigation we noticed that fragmented indexes are the cause of poor query ...Answered | 10 Replies | 3371 Views | Created by SaaimaKhaan - Friday, August 24, 2012 11:36 AM | Last reply by Dan Guzman - Friday, August 31, 2012 10:26 AM -
1 Votes
Query Optimization
In any case how can I optimize the query?Answered | 6 Replies | 3911 Views | Created by LUIS SC - Thursday, December 17, 2009 3:56 PM | Last reply by Kalman Toth - Wednesday, December 23, 2009 11:17 AM -
8 Votes
Query optimizer and techniques
Regards, Ashwin Menon My Blog - http:\\sqllearnings.comAnswered | 8 Replies | 1125 Views | Created by czarvk - Monday, August 11, 2014 7:17 PM | Last reply by Uri Dimant - Saturday, August 16, 2014 2:16 PM -
0 Votes
optimize the query
Hi shivpuje siddu, Take a good look at the execution plan, there might be missing index information generated by the query optimizer.Answered | 3 Replies | 1657 Views | Created by shivpuje siddu - Monday, June 27, 2016 10:33 AM | Last reply by Andrea Caldarone - Tuesday, June 28, 2016 10:15 AM -
0 Votes
Query Optimization
> Could someone please help me optimize/rewrite this query?Answered | 8 Replies | 555 Views | Created by Steviehn - Friday, July 8, 2016 6:21 PM | Last reply by Steviehn - Friday, July 8, 2016 8:20 PM -
0 Votes
query optimization
The operator cost is the amount that that particular operator contributes in the entire query.Answered | 1 Replies | 4729 Views | Created by Vaishu - Wednesday, July 21, 2010 3:36 PM | Last reply by Brad_Schulz - Wednesday, July 21, 2010 3:49 PM -
0 Votes
Query Optimization
USE BEST PRACTICES FOR QUERY OPTIMIZATION : 1.Answered | 2 Replies | 2336 Views | Created by Mak215 - Thursday, August 30, 2012 12:13 PM | Last reply by Badkur - Thursday, August 30, 2012 12:38 PM -
1 Votes
How to Optimized CAML Query ?
narrow down your search by adding proper filter conditions is the only way to ensure that your query is optimized.Answered | 1 Replies | 8662 Views | Created by bdnp - Monday, January 17, 2011 3:16 PM | Last reply by Moonis Tahir - Monday, January 17, 2011 3:48 PM -
0 Votes
The Query optimizer and high latency
This article lead me to ask the question: "How does high latency affect the query optimizer?Answered | 6 Replies | 1361 Views | Created by a141695 - Wednesday, December 24, 2014 7:17 PM | Last reply by a141695 - Saturday, January 10, 2015 1:53 AM -
0 Votes
Optimization of query permormance.
Query optimization requires knowledge.Answered | 5 Replies | 4463 Views | Created by dastagir - Sunday, December 5, 2010 4:11 PM | Last reply by Kalman Toth - Friday, December 10, 2010 7:24 PM -
0 Votes
Reporting Query optimization
Have you got a chance to look at the query execution plan?Answered | 5 Replies | 2678 Views | Created by NJDS - Thursday, August 25, 2011 10:46 PM | Last reply by Debu Basu - Friday, August 26, 2011 5:11 PM - Items 1 to 20 of 1548959 Next ›
No announcements
