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

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 i create

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 scans. I have used separate

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. I