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
If you select table after created clustered index it will show you table scan only see below
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
No comments:
Post a Comment