Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding records to a table
Message
From
20/04/2001 02:17:44
 
 
To
19/04/2001 12:27:29
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00497112
Message ID:
00497735
Views:
10
An index contains key values built from one or more columns in a table. These keys are stored in a structure that allows SQL Server to find rows associated with the key values quickly and efficiently. You can have only one clustered index, create clustered index on a column for eg. employee_id which would be always unique. Your inserts, updates and deletes would definetly become more faster. But before creating index on the table drop all the current indexes and recreate the clustered index. for more help go to MSDN help, or refer to books online of sql server.
Previous
Reply
Map
View

Click here to load this message in the networking platform