On Sun, Jul 13, 2003 at 08:51:15AM -0700, Henry Hank wrote:
>
> I have the following SQL. The source table has 8.1 million rows, and the
> resulting table will have about 7.9 million rows. I know that's not much of a
> decrease, but the logic is correct as I've tested it on smaller sets. The
> p
Henry Hank <[EMAIL PROTECTED]> wrote:
>
> The explain plan isn't anything I wouldn't ordinarily expect - a full table
> scan:
>
> +---+--+---+--+-+--+-+-+
> | table | type | possible_keys | key | key_len | ref | rows| Extra
The explain plan isn't anything I wouldn't ordinarily expect - a full table
scan:
+---+--+---+--+-+--+-+-+
| table | type | possible_keys | key | key_len | ref | rows| Extra
|
+---+--+---+--+--
Henry,
The information you've posted is a good start, can you post the results of
an EXPLAIN command? That would go a long way towards finding a solution.
--Justin
On Sun, 13 Jul 2003, Henry Hank wrote:
>
> I have the following SQL. The source table has 8.1 million rows, and the
> resulting
