No announcements
Found 1278135 threads
-
0 VotesTABLE SCAN vs.
Hi Sandeep Can you please go through the following link please : ...Answered | 2 Replies | 4538 Views | Created by SandeepM_ - Friday, December 18, 2009 10:33 AM | Last reply by Suhas Vallala - Friday, December 18, 2009 11:05 AM
-
0 Votes
Index Seek,Index Scan, Table scan.
Hello Kandan, Basically it depends on number of rows , type of queries & index types , It depends on the requirements too, I think below link will help you to ...Answered | 2 Replies | 1383 Views | Created by Kandan J - Monday, August 29, 2016 3:01 PM | Last reply by Chetan Vishwakarma - Monday, August 29, 2016 3:33 PM -
2 Votes
what is table scan and index scan
Hi, Table scan and index scan are same in sense , table scan happens in Heap tables(tables without any ...Answered | 4 Replies | 3139 Views | Created by v60 - Friday, May 11, 2012 6:20 PM | Last reply by SKB7 - Monday, May 14, 2012 9:38 AM -
1 Votes
what index scan and seek - table scan and seek
There is difference between Index scan and table scan.Answered | 4 Replies | 9662 Views | Created by yangamuniprasad - Thursday, July 5, 2012 4:25 AM | Last reply by Sunil Kumar Gupta - Sunday, October 28, 2012 4:51 PM -
0 Votes
Index Scan vs.
A scan does not mean that it has looked at each and every row on the table.Answered | 6 Replies | 5645 Views | Created by Ashru - Wednesday, April 21, 2010 9:20 AM | Last reply by Brad_Schulz - Wednesday, April 21, 2010 4:02 PM -
2 Votes
Table scan even with index
The table scan is is being used because there is no where clause in the query.Answered | 6 Replies | 900 Views | Created by Bhasker Alle - Wednesday, April 8, 2015 9:41 PM | Last reply by Erland Sommarskog - Thursday, April 9, 2015 8:11 AM -
0 Votes
Collect Table scan & Index Scan Query in Online
Based on my test, you can only collect queries with index scan via Extended Events, it doesn’t seem like you can do it for ...Answered | 9 Replies | 3146 Views | Created by Ajmal Khan M - Monday, November 6, 2017 8:56 AM | Last reply by Dan Guzman - Friday, November 24, 2017 1:23 PM -
0 Votes
Index seek vs index scan
To decrease fragmentation, generally, indexes should be rebuilt every weekend with FILLFACTOR for dynamic tables.Answered | 5 Replies | 2978 Views | Created by Royston Ang - Friday, September 7, 2012 11:00 AM | Last reply by Kalman Toth - Saturday, September 8, 2012 8:29 AM -
0 Votes
Index scan vs index seek
Do a re-compile on sp that is doing an index scan.Answered | 23 Replies | 7704 Views | Created by surendrakavali - Thursday, March 14, 2013 7:18 AM | Last reply by Jackson_1990 - Saturday, October 19, 2013 4:57 AM -
1 Votes
Reg:Which is better either Table Scan or Clustured Index Scan
I would suggest you to use table scan rather than index scan.Answered | 5 Replies | 618 Views | Created by Ramesh Reddy Mallidi - Tuesday, July 3, 2018 12:36 PM | Last reply by TiborK - Wednesday, July 4, 2018 7:16 AM -
0 Votes
Table scan
So the query engine selected the table scan option.Answered | 11 Replies | 7278 Views | Created by Priw - Wednesday, November 28, 2007 4:02 AM | Last reply by elizas - Tuesday, March 30, 2010 11:59 AM -
1 Votes
index scan on a table join, why not index seek?
[colA])) | |--Table Scan(OBJECT:([tempdb].Answered | 2 Replies | 22199 Views | Created by D00linDalton - Friday, March 25, 2011 6:46 PM | Last reply by SQL_Jay - Friday, March 25, 2011 11:43 PM -
0 Votes
Index Scan or Index seek
Hello Zainu, The non-clustered index page would store a pointer to the clustered index entry if a clustered index existed.Answered | 2 Replies | 5417 Views | Created by Zainu - Thursday, November 5, 2009 7:45 AM | Last reply by Arif Hasan - Thursday, November 5, 2009 12:25 PM -
0 Votes
Clustered Index Scan
In this case isn't the index scan required for the State search just as bad as a table scan?Answered | 5 Replies | 6921 Views | Created by D00linDalton - Monday, February 21, 2011 1:18 AM | Last reply by Dan Guzman - Monday, February 21, 2011 5:33 AM -
0 Votes
what is the index scan
please tell me way to prevent index scan.Answered | 4 Replies | 7404 Views | Created by Pawan Rajput - Thursday, March 3, 2011 9:44 PM | Last reply by Chirag Shah - Monday, March 7, 2011 4:15 PM -
1 Votes
index scan to seek
For the OP this is no improvement at all, since the index is covering, so it never needs the Nested Loops to access the table data.Answered | 11 Replies | 7196 Views | Created by psingla - Wednesday, May 4, 2011 7:27 PM | Last reply by Kent Waldrop - Thursday, May 5, 2011 5:47 PM -
2 Votes
Scan Density vs Fragmentation
In small tables u can ignore this as it will remain high.so just rebuild index and share all 3 details.Answered | 6 Replies | 7572 Views | Created by Jason Spatz - Friday, May 30, 2014 3:13 PM | Last reply by SumitSKS - Saturday, June 7, 2014 8:21 AM -
0 Votes
Join two tables without index scan
Pls merge with:Answered | 7 Replies | 1204 Views | Created by Saravanan Durai - Tuesday, March 25, 2014 7:55 AM | Last reply by Jayakumaur (JK) - Tuesday, March 25, 2014 9:33 AM -
0 Votes
Index seek and Index Scan as the tables with primary(Index key) column
In your case, it choose ( based in various factors ) waht the table for scan, and, choose do a Index Seek ( based also in various factors ) in other table.Answered | 4 Replies | 5681 Views | Created by ganeshkuppuswamy - Tuesday, October 28, 2008 9:54 AM | Last reply by RodrigoRRG - Thursday, June 16, 2011 10:58 PM -
0 Votes
Scan table question
Otherwise data access will be through table or index scan.Answered | 6 Replies | 2545 Views | Created by aujong - Thursday, March 29, 2012 5:42 PM | Last reply by Kalman Toth - Monday, April 2, 2012 11:21 AM - Items 1 to 20 of 1278135 Next ›
No announcements
