Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Does SQLServer automatically create an index for an IDENTITY column ?

Status
Not open for further replies.
mb22

mb22

Programmer
Sep 4, 2002
258
US
Does SQLServer automatically create an index for an IDENTITY column ? ... Or do I have to create an index myself if I am going to be running SELECT or UPDATE queries on that column .. for speed?
 
Sort by date Sort by votes
No it does not. You have to create that yourself.

Thanks

J. Kusch
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Triacona
  • Locked
  • Question
How to broadcast data from a SQL server to an IP an Port 2
Replies
5
Views
243
fisheromacse
fisheromacse
RRinTetons
  • Locked
  • Question
Tool for job scheduling
Replies
0
Views
289
RRinTetons
RRinTetons
DougNaf
  • Locked
  • Question
SQL 2016 - DB attachment and error 3415
Replies
1
Views
233
fredericofonseca
fredericofonseca
JoPaBC
  • Locked
  • Question
Delphi/Borland program and SQL Express 2017
Replies
6
Views
522
JoPaBC
JoPaBC
JoPaBC
  • Locked
  • Question
Schedule and automate backups of SQL Express databases in SQL Server Express 1
Replies
5
Views
487
JoPaBC
JoPaBC

Part and Inventory Search

Sponsor

Back
Top