Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
Use of Index in where clause under delete statement
Manish Kumar
Nov 1 2016 8:17 AM
255
Reply
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
Encrypt password in sqlserver
insert only column name into another table