Have you tried dropping the foreign keys and measured the times again?
Have you recalculated the index statistics?


On Wed, 29 Sep 2004 12:05:18 -0300, German Pablo Gentile
<listas.ggentile@...> wrote:

>
> I have a table with a moderated grow rate (100000 records at month).
> Actually have only 100000 records.
> That table have ten ids to ten tables, all have foreign keys. the ids
> inserted in the main table related to the other tables are not unique.