No announcements
Found 1496143 threads
-
1 VotesRegarding the Non-Clustered Indexes
If one of the 10 columns in all of the WHERE clauses is the primary or unique key, make an index on that - which I'd make clustered, or just INCLUDE() the other 19 columns ...Answered | 4 Replies | 672 Views | Created by 15432369 - Thursday, May 19, 2016 3:54 PM | Last reply by Carl G. Sopchak - Thursday, May 19, 2016 11:48 PM
-
3 Votes
clustered index and non clustered index
There can be only one clustered index because clustered index is nothing but the data (at leaf level).Answered | 6 Replies | 6016 Views | Created by Vasavi Machina - Tuesday, June 8, 2010 5:17 AM | Last reply by Lekss - Tuesday, June 8, 2010 10:40 PM -
0 Votes
cluster and non-cluster index
IMO, here are the default rules for indexing a relational design: 1) Have a clustered primary key on every table, plus a unique non-clustered ...Answered | 5 Replies | 1944 Views | Created by shreekanth.k - Sunday, January 20, 2013 4:37 PM | Last reply by davidbaxterbrowne - Sunday, January 20, 2013 7:12 PM -
0 Votes
if clustered index updates then non-clustered index also?
Thanks all, Actually I was reading the deadlock case study in which its mentioned that an update statement trying to update the cluster index and if ...Answered | 5 Replies | 1066 Views | Created by Ajay.G - Friday, October 10, 2014 9:50 AM | Last reply by Ajay.G - Friday, October 10, 2014 10:14 AM -
0 Votes
disadvantages of clustered and non-clustered indexes
Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/Answered | 4 Replies | 29187 Views | Created by chris-339 - Wednesday, February 16, 2011 7:28 PM | Last reply by Uri Dimant - Sunday, February 20, 2011 6:55 AM -
0 Votes
Question on Non-Clustered Index
So does this mean that a copy of the column data which is non clustered index is also available in the leaf page of the non clustered ...Answered | 15 Replies | 6696 Views | Created by SQLUserDBA - Tuesday, June 29, 2010 9:45 AM | Last reply by Gert-Jan Strik - Saturday, July 3, 2010 8:57 AM -
0 Votes
Clustered vs non-clustered index
You can create a non clustered index on the columns you are trying to retrieve in your query.Answered | 6 Replies | 5773 Views | Created by SSDL - Friday, April 9, 2010 7:21 PM | Last reply by Abdshall - Thursday, May 3, 2012 1:52 PM -
1 Votes
Non Cluster Index without Cluster Index???
With a table, the nonclustered index keys refer to the clustered index key (and optional uniquefier).Answered | 7 Replies | 1425 Views | Created by Mak215 - Wednesday, June 12, 2013 8:20 AM | Last reply by TiborK - Wednesday, June 12, 2013 2:29 PM -
0 Votes
Non clustered index
Hi, What is the use of non clustered index in sql server?Answered | 3 Replies | 2719 Views | Created by Surya.chamala - Saturday, September 14, 2013 7:49 PM | Last reply by SathyanarrayananS - Sunday, September 15, 2013 5:55 AM -
1 Votes
clustred Index and non clustered index.
q=clustered+and+nonclustered+indexes.Answered | 3 Replies | 13966 Views | Created by chintalapudi - Thursday, March 3, 2011 9:47 AM | Last reply by StraNGeLaD - Thursday, March 24, 2011 3:41 PM -
0 Votes
Convert unique, non-clustered index to clustered index
Yes, You use the regular CREATE INDEX statement for it, and simply add WITH DROP_EXISTING to it.Answered | 3 Replies | 7777 Views | Created by Amaeze - Wednesday, May 12, 2010 6:22 PM | Last reply by Gert-Jan Strik - Thursday, May 13, 2010 10:17 AM -
0 Votes
clustered index supporting non clustered index.
Cluster index is actual data means a leaf level of the CI contains data 2.Answered | 3 Replies | 601 Views | Created by rajemessage - Friday, October 31, 2014 1:48 PM | Last reply by Uri Dimant - Monday, November 3, 2014 7:28 AM -
2 Votes
Unique, Clustered and Non Clustered indexes on same column
Hello, If you do not have clustered index created, the non-clustered indexes will have pointers to the heap.Answered | 4 Replies | 13395 Views | Created by r_u_j_u - Tuesday, January 12, 2010 7:14 AM | Last reply by Krishna Rajeesh - Wednesday, January 13, 2010 5:48 AM -
0 Votes
How Clustered and non clustered index work on the table
Hi, Clustered indexes sort and store the data rows in the table or view based on their key values.So in your case, the data will be sorted in ...Answered | 2 Replies | 987 Views | Created by DevBi - Friday, January 30, 2015 5:14 AM | Last reply by Janani A T - Friday, January 30, 2015 6:06 AM -
0 Votes
When to Use Clustered Index and Non Clustered Index
Hi Kumar, Check the guidelines When to Use Clustered Index andNonclustered Index .Answered | 3 Replies | 28629 Views | Created by KUMAR_1234 - Monday, December 1, 2008 3:30 PM | Last reply by Syed Shakeer Hussain - Sunday, January 20, 2013 5:10 PM -
0 Votes
non clustered index with pk vs non clustered index without pk
thx, when there is no clustered index, how is a row located via nci?Answered | 5 Replies | 1125 Views | Created by db042190 - Tuesday, August 13, 2019 6:05 PM | Last reply by Erland Sommarskog - Wednesday, August 14, 2019 9:02 PM -
1 Votes
Indexes and non clustered PKs
Clustered indexes usually designed with 2 purposes in mind.Answered | 4 Replies | 1912 Views | Created by warnerrj79 - Monday, April 15, 2013 3:18 PM | Last reply by warnerrj79 - Tuesday, April 16, 2013 8:20 AM -
0 Votes
Non-Clustered Index Question
I created a clustered index on it the with fillfactor 0, 33 ,45 ,65, 80 to see the performance.Answered | 4 Replies | 9077 Views | Created by Muhammad Bilal - Friday, February 18, 2011 6:37 PM | Last reply by Uri Dimant - Sunday, February 20, 2011 6:44 AM -
7 Votes
sql server 2012 - cluster and non cluster indexes
Non cluster index is of no use to decrease the time for query.Answered | 24 Replies | 4304 Views | Created by h2007 - Monday, September 2, 2013 8:18 AM | Last reply by Dean Savović - Monday, September 30, 2013 7:22 AM -
1 Votes
Space occupied by clustered index Vs non-clustered index
Hi czarvk, Clustered index in SQL Server takes up more space than non-clustered indexes.Answered | 1 Replies | 1659 Views | Created by czarvk - Thursday, October 23, 2014 5:25 PM | Last reply by Donghui Li - Friday, October 24, 2014 10:12 AM - Items 1 to 20 of 1496143 Next ›
No announcements
