Hello.
See:
http://dev.mysql.com/doc/mysql/en/how-to-avoid-table-scan.html
David Kagiri <[EMAIL PROTECTED]> wrote:
> [-- text/plain, encoding 8bit, charset: iso-8859-1, 15 lines --]
>
> Hi
> I our database there is one table that will grow into tetrabytes within a
> short time.
PROTECTED]
Cc: mysql
Subject: Re: Avoiding full table scans
David Kagiri <[EMAIL PROTECTED]> wrote on 30/06/2005 09:44:11:
> Hi
> I our database there is one table that will grow into tetrabytes
> within a short time.
>
> I would like to know how i can reduce full table sc
David Kagiri <[EMAIL PROTECTED]> wrote on 30/06/2005 09:44:11:
> Hi
> I our database there is one table that will grow into tetrabytes
> within a short time.
>
> I would like to know how i can reduce full table scans.
>
> I have used separate tables as per region for now but the problem is
> if
Hi
I our database there is one table that will grow into tetrabytes within a short
time.
I would like to know how i can reduce full table scans.
I have used separate tables as per region for now but the problem is if i
create a new table i am forced to recompile the application.
I can easil