Skip navigation links

MySQL Forums :: MaxDB :: Query Parallelism and Multiple Volumes


Advanced Search

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?

-Frank

Options: ReplyQuote


Subject Written By Posted
Query Parallelism and Multiple Volumes F A 04/04/2007 10:52AM
Re: Query Parallelism and Multiple Volumes F A 04/09/2007 03:10PM
Re: Query Parallelism and Multiple Volumes Jonah Harris 04/24/2007 11:54AM
Re: Query Parallelism and Multiple Volumes Ulf Wendel 05/14/2007 06:00AM


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.