I suggest that you add more indexes to your tables. If you run an EXPLAIN
on your query, you will see that you are doing WAY too many table scans and
that is what is slowing you down. Index the columns in each table that
reference the ID values of another table. Then run your EXPLAIN again and
you
This is an index problem. Your tables don't contain any indices except on
PKs. This can't work, given the number of joins and table sizes. Read the
doc about indices.
Stefan
Am Monday 12 July 2004 09:55 schrieb Jeyabalan Murugesan Sankarasubramanian:
> Hi All,
>
> I migrated the data from Oracle
