Download
100% FREE
Office Document APIs for .NET
Online: 1002
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Forums
>
Interview Questions
>
Loading ...
How many clustered index can we create in a single table?
Posted by
Prabu_Spark
under
Interview Questions
on 2/4/2014 |
Points: 10
| Views : 1904 | Status :
[Member]
| Replies : 3
Write New Post
|
Search Forums
|
Resolved Posts
|
Un Answered Posts
|
Forums Home
Hi sir,
How many clustered index can we create in a single table? Kindly give me the solution for this question.
With regards,
J.Prabu.
[Email:prbspark@gmail.com]
Reply
|
Reply with Attachment
Alert Moderator
Responses
Posted by:
Sravan661
on: 2/4/2014
[Member]
Bronze
|
Points: 25
0
Hi,
we can create only
one
clustered index for a table
fyi if you create a primary key automatically clustered index will be created for that column
Non clustered index can be multiple
for more information on this please see the url
http://www.codeproject.com/Articles/173275/Clustered-and-Non-Clustered-Index-in-SQL-2005
sravan
Prabu_Spark
, if this helps please
login
to
Mark As Answer
. |
Alert Moderator
Posted by:
Sureshij
on: 2/4/2014
[Member]
Starter
|
Points: 25
0
Yes we can create
ONLY ONE clustered index
on a single table. By default Primary key will create clustered index on the primary key columns. If you wish to create non-clustered index on primary key (PK) column you should mention
PRIMARY KEY NONCLUSTERED
clause while PK creation.
By the way you can create more than one nonclustered indexes on a single table.
ij
Prabu_Spark
, if this helps please
login
to
Mark As Answer
. |
Alert Moderator
Posted by:
Snaveen
on: 2/13/2014
[Member]
Starter
|
Points: 25
0
Hi,
In a table you can able to create only one clustered index.
Similallarly in sql 2005 you can able to create 249 non-clustered indexes and in s1l -2008 you can able to create 999 non- clustered indexes.
Prabu_Spark
, if this helps please
login
to
Mark As Answer
. |
Alert Moderator
Login to post response
Latest Posts
Manufacturer of Steel Grey Granite in India Best Supplier Natura MarmoGranite
(0)
New
code first migration error in mvc
(1)
How to update for this interval
(1)
How to List particular Records in sql server
(1)
How to get multiple selected checkbox value to controller in mvc
(3)
Object comparison in jQuery
(1)
How to Update Dynamic File
(0)
How to use middle war to get next request asp.net core 2 ?
(3)
More ...