Counter of Festivals

Ashok Blog for SQL Learners and Beginners and Experts

Monday 6 April 2015

Can we able to create Clustered Index on Alpha Numeric Column or Not Primary Key Column in Table?

Can we able to create Clustered Index on Alpha Numeric Column or Not Primary Key Column in Table?

No You cant able to create Clustered Index Key on Varchar/AlphaNumberic/Non Primary Key column but u can able to create Non Clustered Index Key but it will not show u while u select column


Actually It can able to create it on table but table scan only happened while you select table bcos table cant physically order table using alpha numeric column




If you select table after created clustered index it will show you table scan only see below



If alpha Numeric column would be non duplicate value then we can able to create clustered index key




No comments:

Post a Comment