Query Parallelism and Multiple Volumes

[F A]

This question concerns query parallelism on simple queries and multiple volumes in MaxDB.

Table1 has 5,000 records and Table2 has 100,000,000 records with indexes on the field ID.

Given that a database is spread over multiple volumes (multiple hard drives) and given the following:

Select SomeField from Table1, Table2 Where Table1.ID = Table2.ID

If such a database is given the above SQL query, will the database access all of the separate volumes in parallel or in series to look up the indexed values on Table2 and resolve the join?

-Frank