Greetings, Oh Massed Experience and Intellect!

Which costs more, select from media or select from volumes? Or are they
similar enough to flip a coin? I am trying to write a script in which I need
to know which storage pool a given tape belongs to. Looking at the list of
columns, it looks like I can

select stgpool_name from volumes where volume_name='$volume_name'

or

select stgpool_name from media where volume_name='$volume_name'

When I run both commands alone, select from media seems to return a quarter
second faster, but that is pretty skimpy evidence.... timex says it depends on
cached data....

I'll use select from media unless there is a better way.

Platform is ADSM 3.1.2.20 on AIX 4.?

TIA,
Kai.