Re: Avoiding full table scans

2005-06-30 Thread Gleb Paharenko
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.

RE: Avoiding full table scans

2005-06-30 Thread emierzwa
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

Re: Avoiding full table scans

2005-06-30 Thread Alec . Cawley
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

Avoiding full table scans

2005-06-30 Thread David Kagiri
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