Problem with indices

[huffie]

I am executing this query. The execution time is unacceptable (1 minute for 2000 records). Can anybody tell me how i can optimize my sql or my indices in the tables?

select art.art,art.desc,book1.cust,book1.price
from PUB.art
join PUB.prbk as book1
on art.company='company1'
and art.company=book1.company
and book1.grp='00000526'
and art.art=book1.art
and book1.cust=(
select max(book2.cust)
from PUB.prbk as book2
where book1.company=book2.company
and book1.grp=book2.grp
and book1.art=book2.art
and (book2.cust='BRONFRITUUR' or book2.cust=''))

Table art:
fields: company,art,desc
index: company+art

Table prbk
fields: company,art,grp,cust,price
index: company+grp+art+cust

[mwasif]

Do you have combine indices on company+art AND company+grp+art+cust?

The following condition in JOIN should go to WHERE instead
art.company='company1'
AND book1.grp='00000526'

Use explain to find out the bottleneck.