issues bout storage

Hi,
I have two questions on data storage:
say, there is an employee table contains 1000 employee records.

1. what would you do if queries frequently use salary range as well as department?
2. what buffer replacement policy will you use if the buffer can contain 5 employee records at a time and the user tries to sort employees by their SSN?

thanks
quyin

--
Posted via http://dbforums.com