I have the folowing two tables.
employee_master (
emp_rid int primary key identity,
emp_no char(20) not null,
emp_name varchar(100)
);
salary_payment(
sp_rid int primary key,
sp_emp_rid int COMMENT 'Maping employee_master .emp_rid',
sp_pay_date date COMMENT 'Payment Date',
sp_amount varchar(100)
);
Assume in index is created on the fields salary_payment( sp_emp_rid).
Here I need to get all the salary payment details for particular employee
having emp_rid 10234.
For this I have two ways of writing querries.
Method 1:
select * from employee_master
join salary_payment on emp_rid = sp_emp_rid
where emp_rid = 10234
Method 2:
select * from employee_master
join salary_payment on (emp_rid = 10234 = and emp_rid = sp_emp_rid)
Question:
Will these methods make the difference in performance, if yes, how?
employee_master (
emp_rid int primary key identity,
emp_no char(20) not null,
emp_name varchar(100)
);
salary_payment(
sp_rid int primary key,
sp_emp_rid int COMMENT 'Maping employee_master .emp_rid',
sp_pay_date date COMMENT 'Payment Date',
sp_amount varchar(100)
);
Assume in index is created on the fields salary_payment( sp_emp_rid).
Here I need to get all the salary payment details for particular employee
having emp_rid 10234.
For this I have two ways of writing querries.
Method 1:
select * from employee_master
join salary_payment on emp_rid = sp_emp_rid
where emp_rid = 10234
Method 2:
select * from employee_master
join salary_payment on (emp_rid = 10234 = and emp_rid = sp_emp_rid)
Question:
Will these methods make the difference in performance, if yes, how?
Comment