Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Haja Mohideen
Starting Member
12 Posts |
 Posted - 2014-12-24 : 02:41:35
|
| Dear Friends,I have 5 million rows of table, and going to create Non Clustered Index for Datetime values column. Can you please share your idea about it creating Non clustered Index on Datetime value column will affect performance or not. If it will give poor performance means then kindly share me your valuable point that you have.Or Share any website link that contain this informationNothing is impossible |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2014-12-24 : 03:00:44
|
| just blindly creating an index on datetime columns would not help,it would be a overhead.you need to make sure that the columns you are planning to create index on are being used in joins and where conditions.you may also want to check the execution plans to find right candidates for indexing.check this http://sqlmag.com/database-performance-tuning/indexing-dos-and-don-tsJaveed Ahmedhttps://www.linkedin.com/pub/javeed-ahmed/25/5b/95 |
 |
|
|
Haja Mohideen
Starting Member
12 Posts |
Posted - 2014-12-24 : 04:10:56
|
| Dear Javeed Ahmed,Thank you so much for your information,Of course, I am going to create NCI to purpose fully which is the column used in where clause.The column name is 'Received_Date' and this data type is datetime. my doubt is creating non-cluster on a datetime type column will cause performance issue or not. I go through the link which u mentioned. Thanks again Nothing is impossible |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2014-12-24 : 05:04:38
|
| you can create NCI on it,no issuesJaveed Ahmedhttps://www.linkedin.com/pub/javeed-ahmed/25/5b/95 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-12-24 : 10:34:00
|
| A non-clustered index on a datetime that is often used in a WHERE clause is a great idea! Some love the idea of it being the clustered index.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Creating a Non clustered Index on DateTime column