Use of Index in where clause under delete statement

Question

Does where condition in delete statement looks for an index for example: delete from mytable where insertedon>='2015/02/01' if there is no index on mytable does it go for table scan (among millions of records) as per my understanding (please correct me if i am wrong)  if there is no index on a table then DML operation will work fast as there is no index maintenance. Thanks Manish

Bulbul Ahmed · Answer

Check the below links. It might help you. Check the approved answer of Stackoverflow and then read the details of below link. 1. http://stackoverflow.com/questions/3453833/sql-server-delete-is-slower-with-indexes 2. http://use-the-index-luke.com/sql/dml/delete

Manas Mohapatra · Answer

Index on a date column will not be use if your application use datetime which cause implicit data type conversion. If you are using columns like char int tinyint or bool. It wont be that much improve your performance for date column. https://social.msdn.microsoft.com/Forums/sqlserver/en-US/03b88da7-b5f1-47f6-a908-727d4412af2a/datetime-column-not-using-index?forum=transactsql

Bikesh Srivastava · Answer

you can create index on sql table column