List:Internals« Previous MessageNext Message »
From:Antony T Curtis Date:March 6 2001 12:12pm
Subject:Re: Optimisation suggestion...
View as plain text  
Enrique Villar wrote:
> 
> Hi!
> If you have a n rows table of x char. each. in disk of 4k pagesize, having
> an index of y chars. per entry, with i entries. Selecting r number of rows
> matching your WHERE restriction has the following plans and associated
> costs:

<snip>

Thanks! You've saved me from the thoretical work :D


-- 
ANTONY T CURTIS                     Tel: +44 (1635) 36222
Abacus Polar Holdings Ltd           Fax: +44 (1635) 38670
> Did you know that clones never use mirrors?
> 		-- Ambrose Bierce, "The Devil's Dictionary"
Thread
character set conf fileChi-Wai Lau21 Feb
  • character set conf fileMichael Widenius21 Feb
  • Optimisation suggestion...Antony T Curtis21 Feb
    • Re: Optimisation suggestion...Thimble Smith21 Feb
  • Re: Optimisation suggestion...Antony T Curtis21 Feb
    • Re: Optimisation suggestion...Michael Widenius5 Mar
  • Re: Optimisation suggestion...Antony T Curtis5 Mar
    • Re: Optimisation suggestion...Michael Widenius5 Mar
  • Re: Optimisation suggestion...Antony T Curtis6 Mar
RE: Optimisation suggestion...Enrique Villar6 Mar
  • Re: Optimisation suggestion...Antony T Curtis6 Mar