List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 18 1999 1:11am
Subject:Re: select doesn't seem to be using index
View as plain text  
At 7:39 PM -0500 9/17/99, a rancid amoeba wrote:
>I gather from the manual that you can index only part of a column which
>is exactly what I want to do but it doesn't appear that the select
>statement (to me at least) is using the index.

No comment on the rest of your message, but you can index a full column
(unless it's a BLOB or TEXT type, then you must index just a prefix).

The general rule is that for string types you *may* index a prefix,
but are not required to.

--
Paul DuBois, paul@stripped
Thread
select doesn't seem to be using indexa rancid amoeba18 Sep
  • Re: select doesn't seem to be using indexPaul DuBois18 Sep
  • Re: select doesn't seem to be using indexBenjamin Pflugmann18 Sep
    • Re: select doesn't seem to be using indexMartin Ramsch18 Sep
    • Re: select doesn't seem to be using indexa rancid amoeba18 Sep
      • Re: select doesn't seem to be using indexBenjamin Pflugmann19 Sep
        • Re: select doesn't seem to be using indexa rancid amoeba19 Sep
          • Re: select doesn't seem to be using indexMichael Widenius20 Sep
        • similar question plus ORDER BY (was Re: select doesn't seem to be using index)AAron nAAs20 Sep
      • Re: select doesn't seem to be using indexMichael Widenius19 Sep