SQL & PL/SQL

Hello

I have a table which has 39 million rows , this table is partitioned on one of the columns . I have a query which uses this table
but the where clause has nothing to do with the partitioned column. My query is doing a full table scan on this table and it takes approx
more that 2 minutes for retrieving the data...BTW this query is in a script...and the script uses this query around 3 million times so you
can imagine how long the script takes to execute..Here is the short example of my table and the query


Table columns:

employee number
Name
Address
banknumber
Account number

This table is partitioned on the basis of Employee number

My query
select banknumber from employee where account_number =12345

The table has 39 million rows

Please advise