Query Speed

[Jonathan]

Hello.
I have table EMP with following fields:

NAME VARCHAR2(256)
DEPARTMENT VARCHAR2(10)
EMPNUM VARCHAR2(10)
SALARY VARCHAR2(10)

My Select is:

SELECT NAME FROM EMP WHERE DEPARTMENT='5' and EMPNUM='456' and SALARY='12345';

My Question is:
How I should design the table and DataBase ( and what DB it's better to use)
in order that select will return the resulst with maximal speed.

Thanks a lot,
Jonathan Kukin

[al]

You can use indexes on those 3 columns, that will speed up some of the searching. You can use any RDBMS which supports stored procedures and that will also speed up a little bit your client ans server response time.

Hope that helps.

P.S. Do not use MS Access
------------
Jonathan at 4/12/01 5:56:08 AM

Hello.
I have table EMP with following fields:

NAME VARCHAR2(256)
DEPARTMENT VARCHAR2(10)
EMPNUM VARCHAR2(10)
SALARY VARCHAR2(10)

My Select is:

SELECT NAME FROM EMP WHERE DEPARTMENT='5' and EMPNUM='456' and SALARY='12345';

My Question is:
How I should design the table and DataBase ( and what DB it's better to use)
in order that select will return the resulst with maximal speed.

Thanks a lot,
Jonathan Kukin