performance required in select statement

hi gurus,

my select statement below is taking around 15 sec to execute, need your help in this regard.

select single * from tablename where no = itab-no.

Thanks,

vj