jjc_mn
asked on
Which sql query would go faster?
select * from table where number = '1' and insert_date > sysdate -1
or
select * from table where insert_date > sysdate -1 and number = '1'
or
select * from table where insert_date > sysdate -1 and number = '1'
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Both are using same where , but it depens on your size of table
>>but it depens on your size of table
In Oracle?
In Oracle?
ASKER