MySQL Forums
Forum List  »  MaxDB

Query Parallelism and Multiple Volumes
Posted by: F A
Date: April 04, 2007 10:52AM

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?


Options: ReplyQuote

Written By
Query Parallelism and Multiple Volumes
April 04, 2007 10:52AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.