TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Manish Kumar
NA
1.4k
8.2k
Use of Index in where clause under delete statement
Nov 1 2016 8:17 AM
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
Reply
Answers (
3
)
Encrypt password in sqlserver
insert only column name into another table