I have two tables :
D_EMPLOYEE -- Primary key (Employee ID)
D_EMPLOYEE_DETAIL -- Foreign key (Employee ID)
D_EMPLYEE contains the employee name and
D_EMPLOYEE_DETAIL contains the details of a perticular employee.
I want to perform a search for a perticular employee by providing his name and retrive the employee code that is stored in
This is a simple query but the problem is that the database size is extremely huge and name column has no index due to which it takes larger time than usual.
Please help me any alternative to search from such a huge database in fraction of sec?