Big tables
From: Raimundo Lozano <rlozano_at_medicina.ub.es>
Date: 2000/02/16
Message-ID: <38AA6450.DDA33B15_at_medicina.ub.es>#1/1
Date: 2000/02/16
Message-ID: <38AA6450.DDA33B15_at_medicina.ub.es>#1/1
I don't have much experience with big tables that contain millions of
rows. So, my concern is how to manage joins between many of such tables.
I think there are two possible solutions:
- At the level of the database structure: To split the tables by some
attribute for deal with smaller ones.
- At the level of SQL sentences: To divide one sentence that contain the
join in many steps, using temporary tables, etc.
What do you think about?
Cheers,
Raimundo Lozano Received on Wed Feb 16 2000 - 00:00:00 CET