Performance issue

hi folks,

Here I have the following select statement which is posing a performance issue. I just need a single field record from this table

hence the query goes like this..

select name_org1 INto adname from

but000 where partner = adnumber.

endselect.

If I do not include endselect statement the query poses an error, and select .... endselect poses performance issue.

How can i improve this query without using the internal table. Because I have to create another internaltable just to get one field of data. Is there a better way of doing it?

Thanks

Santhosh