No announcements
Found 645125 threads
-
0 VotesComposite Index
It is bery possible to have a composite index on the table Composite indexes work just like regular indexes, except they have ...Answered | 2 Replies | 849 Views | Created by AngaraKiran - Tuesday, April 25, 2017 3:06 AM | Last reply by Shanky_621 - Thursday, April 27, 2017 4:58 AM
-
1 Votes
Composite index
The following articles explains in detail how to use and optimize composite inexes Optimizing SQL Server Composite ...Answered | 2 Replies | 3579 Views | Created by goms - Thursday, November 26, 2009 12:22 PM | Last reply by Chirag Shah - Thursday, November 26, 2009 12:32 PM -
0 Votes
composite index
Have a read of Joe Webb's blog on describing a composite index - http://weblogs.sqlteam.com/joew/archive/2008/02/13/60510.aspx I hope this ...Answered | 2 Replies | 2482 Views | Created by ShivaGS - Monday, November 14, 2011 11:35 AM | Last reply by Warwick Rudd - Monday, November 14, 2011 11:46 AM -
1 Votes
Composite primary Key - Index
How does the clustered index page structured for composite primary key?Answered | 6 Replies | 6697 Views | Created by Santhi Dhanus - Friday, December 9, 2011 1:48 PM | Last reply by Kalman Toth - Friday, December 9, 2011 3:47 PM -
1 Votes
Composite Clustered indexes
How does making a clustered index "composite" impacts the performance of the index?Answered | 2 Replies | 14265 Views | Created by vinay dvd - Friday, February 11, 2011 6:44 AM | Last reply by vinay dvd - Saturday, February 12, 2011 1:18 PM -
0 Votes
Composite index help?
If it is the clustered index key, then you don't need to include it on any of the non-clustered indexes because the clustered key is a part of nonclustered indexes by ...Answered | 3 Replies | 3817 Views | Created by Wicked Weapon - Thursday, August 6, 2009 4:41 AM | Last reply by Wicked Weapon - Thursday, August 6, 2009 1:42 PM -
0 Votes
composite primary keys versus composite unique indexes
Is your primary key also presently your clustered index?Answered | 1 Replies | 6805 Views | Created by Membrane - Tuesday, February 20, 2007 1:57 PM | Last reply by Kent Waldrop _ - Tuesday, February 20, 2007 3:36 PM -
2 Votes
Gender(-), Salary composite clustered index
Gender(-) is because you have created the Clustered index with gender DESC Create table temp1 ( id int, Gender char(1), Salary int ) GO Create ...Answered | 2 Replies | 731 Views | Created by rmohan raj - Tuesday, November 24, 2015 12:45 PM | Last reply by SaravanaC - Tuesday, November 24, 2015 1:19 PM -
0 Votes
UNIQUE NONCLUSTERED INDEX or COMPOSITE PRIMARY KEY
Single column/composite UNIQUE KEY or UNIQUE index on NATURAL KEY(s) with CI or NCI 3.Answered | 8 Replies | 8412 Views | Created by PadmaSatya - Saturday, October 20, 2012 1:42 PM | Last reply by Erland Sommarskog - Saturday, October 20, 2012 8:06 PM -
0 Votes
Are all columns in Composite Primary Key indexed?
If you right-click the primary key index under the Indexes node and select properties, you will see the index keys in column order.Answered | 4 Replies | 3262 Views | Created by Ryan0827 - Thursday, June 21, 2012 7:11 PM | Last reply by Dan Guzman - Thursday, June 21, 2012 8:25 PM -
0 Votes
how and when SQL Use Composite index
The queries 1, 3 and 4 can seek the index to find the qualifying rows, because ID is the leading column in the index.Answered | 12 Replies | 11892 Views | Created by Shanu_Shri - Wednesday, January 19, 2011 1:58 PM | Last reply by Gert-Jan Strik - Wednesday, January 19, 2011 6:24 PM -
0 Votes
Why is PK included in 'recommended' composite index
It will be the covering index, e.g. the index that covers the whole query.Answered | 1 Replies | 3810 Views | Created by Meade1 - Monday, November 7, 2011 8:54 PM | Last reply by Naomi N - Tuesday, November 8, 2011 4:30 AM -
3 Votes
When there is a composite index and those columns are in query, does it use index seek?
i think it will use index scan since you are using OR condition in the where clause.. and what also matters is the columns in the index structure. index ...Answered | 4 Replies | 839 Views | Created by Mayooran99 - Saturday, April 25, 2015 2:14 PM | Last reply by Dan Guzman - Saturday, April 25, 2015 4:41 PM -
1 Votes
SharePoint Database table indexes
Is there any documentation available on when SharePoint 2007 adds or deletes databases?Answered | 4 Replies | 3906 Views | Created by mbuckingham - Tuesday, December 6, 2011 9:04 PM | Last reply by mbuckingham - Wednesday, December 7, 2011 2:35 AM -
0 Votes
Composite index or not on a huge table with
If so, then your current clustered index is optimized for inserting new data.Answered | 5 Replies | 6674 Views | Created by Endelm - Tuesday, December 28, 2010 9:20 AM | Last reply by Endelm - Tuesday, December 28, 2010 11:42 PM -
0 Votes
PDF Indexing in Sharepoint Lists with Outlook 2007 (using Microsoft BPOS) not working
I would highly recommend checking the Outlook forum for this: http://social.technet.microsoft.com/Forums/en-us/outlook/threads Basically, from what I gather you are ...Answered | 2 Replies | 4035 Views | Created by Pierceval - Monday, December 20, 2010 3:55 PM | Last reply by Daniel Trautman - Wednesday, December 22, 2010 7:57 AM -
0 Votes
Clustered Index on Composite Key with Timeseries (GroupID, Timestamp)
I think the existing composite clustered index will support the queries you mentioned quite well.Answered | 6 Replies | 1844 Views | Created by Erbse - Friday, November 18, 2016 1:18 PM | Last reply by Erbse - Tuesday, November 22, 2016 2:22 PM -
0 Votes
Composite Indexing in Sharepoint 2007?
Hi, We can implement cascade drop down lists by JavaScript or third-party tool to achieve composite index.Answered | 1 Replies | 3675 Views | Created by Mari Bennett - Wednesday, December 7, 2011 11:42 PM | Last reply by Emir Liu - Thursday, December 8, 2011 11:10 AM -
0 Votes
Give more information about composite and primary key
there is no "composite key" hehehe. all there is a "composite index" and "composite pk" hahaha.Answered | 7 Replies | 5671 Views | Created by silapatil - Monday, August 1, 2011 4:33 PM | Last reply by navogel - Wednesday, August 10, 2011 3:35 PM -
3 Votes
how to create a composite nonclustered index using sql server management studio
I'm not sure exactly where you mean with the Manage Index and Keys dialogues box, but you can create it from the Indexes node in the Object Explorer ...Answered | 2 Replies | 1332 Views | Created by Rainbow55 - Sunday, December 7, 2014 9:22 PM | Last reply by Kalman Toth - Monday, December 8, 2014 7:33 AM - Items 1 to 20 of 645125 Next ›
No announcements
