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
Ayyappan M
NA
1
1.2k
Help on SQL query
Nov 30 2011 9:12 AM
Hi,
Can you let me know, which of the following query execution gives better performance.
Also, the table
T1 is not indexed and the table can have 100,000 records.
Case 1:
DELETE FROM T1 where NAME = 'Ayyappan'
DELETE FROM T1 where NAME = 'Manivel'
Case2:
DELETE FROM T1 where NAME in ('Ayyappan', 'Manivel')
Reply
Answers (
4
)
How to create a stored procedure in sqlserver to return value by taking input parameter
What is the wildcard character in SQL