ECTED]
Sankarasubramaniacc:
n" Fax to:
<[EMAIL PROTECTED] Subject: Sq
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
Hi All,
I migrated the data from Oracle to MySQL.The following query works fine with Oracle
whereas in MySql its hanging.
SELECT distinct caty.name, caty.c_id, caty.notes, count(distinct segs.in_id) as num
FROM segs, caty, st_mbers, t_mbers, p_mbrs, pr_mbers
where segs.c_id = caty.c_id and caty
