Hi All,

If I got one table A_table with many columns, and a second table B_table is
the same but with just primary field and unique field...
How much meaningful is the time difference between these queries?
1. SELECT unique_field FROM A_table WHERE prim_field='val';
2. SELECT unique_field FROM B_table WHERE prim_field='val';

If I split A_table into some tables, and define C_table to be MERGE on the
A_table pieces.
Is the time difference between selecting from A_table or C_table is
meaningful?


thanks in advance,
-Lorderon.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to