No announcements
Found 2400735 threads
-
1 VotesDifference between two Unique Indexes
My Indexes have the following columns: Unique Primary Key Col1, Col3, Col4, Col5 Unique ...Answered | 3 Replies | 996 Views | Created by Bangaaram - Thursday, February 21, 2019 8:42 PM | Last reply by Bangaaram - Friday, February 22, 2019 1:22 PM
-
0 Votes
whats the difference between these Indexes?
Hi Greaso, Unique indexes and included columns are 2 totally seperate concepts.Answered | 2 Replies | 3569 Views | Created by greaso - Tuesday, February 14, 2012 1:33 PM | Last reply by SimpleSQL - Tuesday, February 14, 2012 1:47 PM -
1 Votes
Difference between Primary key with clustered index and primary key with nonclustered index.
The main difference between a Primary key and a Unique Key that a Unique key will allow a null value (albeit only one) whereas a Primary Key won't.Answered | 5 Replies | 20533 Views | Created by SathyJay - Friday, July 19, 2013 11:14 AM | Last reply by Anthony C-UK - Friday, June 26, 2015 2:30 PM -
0 Votes
Unique Clustered index?
what ever is the index type you select it will not effect the results row count for the matching key.Answered | 6 Replies | 5133 Views | Created by Mr Shaw - Thursday, March 18, 2010 5:25 PM | Last reply by Ranjith Kumar S - Friday, March 19, 2010 10:32 AM -
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 | 7784 Views | Created by Amaeze - Wednesday, May 12, 2010 6:22 PM | Last reply by Gert-Jan Strik - Thursday, May 13, 2010 10:17 AM -
5 Votes
What 's difference between Unique key and unique index
Differences between UNIQUE KEY and UNIQUE INDEX: 1.Answered | 9 Replies | 32460 Views | Created by Derek Dai - Tuesday, November 13, 2007 2:58 AM | Last reply by Jim In Idaho - Wednesday, September 12, 2018 6:38 PM -
2 Votes
difference between cluster index and noncluster index
When you create a unique key by default non clustered index will be created internally.Answered | 9 Replies | 8344 Views | Created by nitinsharma1983 - Friday, July 15, 2011 7:40 AM | Last reply by PradeepKushwaha - Wednesday, May 2, 2012 10:11 AM -
0 Votes
what is difference between clustred and non-clustred index
When you designate a column as PRIMARY KEY, SQL Server by default makes it into a unique clustered index.Answered | 7 Replies | 4988 Views | Created by mohanraju2010 - Wednesday, March 31, 2010 7:21 PM | Last reply by Dmitry Yudin - Tuesday, April 6, 2010 9:09 AM -
2 Votes
Unique, Clustered and Non Clustered indexes on same column
I agree with Tibor that one unique clustered index should be enough.Answered | 4 Replies | 13399 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
replace a unique clustered index with a clustered PK
You can't call a unique clustered index PK, it sounds like the best candidate (again I don't know your complete table structure) for PK though.Answered | 6 Replies | 1821 Views | Created by JRStern - Tuesday, June 4, 2013 4:49 PM | Last reply by HITgrunt - Wednesday, June 5, 2013 4:05 AM -
0 Votes
applying Unique,Non-Clustered Index difference between 2000 and 2008 R2
The SQL 2000 index may have been created with: IGNORE_DUP_KEY Controls what happens when an attempt is made to insert a duplicate key value ...Answered | 5 Replies | 2509 Views | Created by vishal.... _ - Monday, November 26, 2012 3:34 PM | Last reply by Kalman Toth - Sunday, December 2, 2012 1:35 AM -
1 Votes
Difference between Non Clustered and Column Store Index
So wven if we can more or less mix freely between clustered/non-clustered "regular indexes" and clustered/non-clustered ...Answered | 4 Replies | 1353 Views | Created by dbadays - Monday, August 22, 2016 5:33 AM | Last reply by dbadays - Tuesday, August 23, 2016 10:05 AM -
0 Votes
partitioning with unique non-clustered index.
If your requirement is to create a unique index that doesn't include the partitioning key, you can create a non-partitioned index even of the table and other ...Answered | 4 Replies | 6085 Views | Created by BurtKing - Friday, September 16, 2011 8:25 PM | Last reply by Dan Guzman - Sunday, September 18, 2011 1:16 PM -
0 Votes
Can you please differentiate blw Unique Clustered Index and Non Unique Clustered Index.
UNIQUE CLUSTERED INDEX is typically used for PRIMARY or UNIQUE KEYs.Answered | 3 Replies | 2710 Views | Created by Raj. K - Wednesday, March 14, 2012 4:26 PM | Last reply by Kalman Toth - Tuesday, March 20, 2012 8:40 PM -
0 Votes
what is the difference between covering and included indexes ?
A clustered index is a covering index by definition, but the adjetive is mainly used for non-clustered indexes.Answered | 5 Replies | 14536 Views | Created by Prasad Yangamuni - Thursday, June 23, 2011 1:01 PM | Last reply by Prasad Yangamuni - Friday, June 24, 2011 4:15 AM -
3 Votes
Difference between Index on Table and Index on View
http://stackoverflow.com/questions/2595136/what-is-the-difference-between-an-table-index-and-a-view-indexAnswered | 4 Replies | 8978 Views | Created by Sambasiva Reddy - Thursday, March 15, 2012 11:57 AM | Last reply by willsonsingh - Saturday, March 17, 2012 8:46 AM -
0 Votes
Difference between cluster and non clustter index
A clustered index has the data pages at the leaf of the index, and therefore there can only be one clustered index on a table.Answered | 3 Replies | 690 Views | Created by Ajay Singh Rawat - Sunday, July 26, 2015 8:28 AM | Last reply by Erland Sommarskog - Sunday, July 26, 2015 11:00 AM -
1 Votes
what is the difference between the drop and create the index and rebuild index ?
In addition to the other posts: For a clustered index, there is a huge difference.Answered | 6 Replies | 1060 Views | Created by rupc - Friday, February 20, 2015 3:59 AM | Last reply by Erland Sommarskog - Friday, February 20, 2015 8:32 AM -
2 Votes
clustered index
When you create a table without creating a clustered index, then this is called a heap.Answered | 11 Replies | 2316 Views | Created by arkiboys - Wednesday, June 13, 2012 11:40 AM | Last reply by Satheesh Variath - Wednesday, June 13, 2012 12:36 PM -
1 Votes
Non Unique Non-Clustered index sort order
sorry , i should have been clearer. what i meant was if there are 100 records with SMITH last name, how are these 100 records stored within the B tree of the non-clustered ...Answered | 7 Replies | 1551 Views | Created by MS_Prog - Friday, October 7, 2016 4:05 AM | Last reply by Uri Dimant - Sunday, October 9, 2016 5:39 AM - Items 1 to 20 of 2400735 Next ›
No announcements
