MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Joseph Bueno Date:September 15 2003 4:46pm
Subject:Re: Select distinct speed on an indexed column
View as plain text  
Since your primary key is used, maybe you should consider adding an
index on PostedZpdi field only.

You may also check 'key_buffer_size' value (show variables like 'key%').
Since your primary key is more than 200 MB big, allocating a "big" key
buffer (> 256MB) may help.

Joseph Bueno

Nathan Cassano wrote:
> mysql> explain select distinct AccountLevelId from PostedZpdi;
> +------------+-------+---------------+---------+---------+------+---------+-
> ------------+
> | table      | type  | possible_keys | key     | key_len | ref  | rows    |
> Extra       |
> +------------+-------+---------------+---------+---------+------+---------+-
> ------------+
> | PostedZpdi | index | NULL          | PRIMARY |      60 | NULL | 3447290 |
> Using index |
> +------------+-------+---------------+---------+---------+------+---------+-
> ------------+
> 1 row in set (0.01 sec)
> 
> 
>>Hi,
>>
>>What do you get when you do an EXPLAIN of your query ?
>>
>>--
>>Joseph Bueno
> 
> 


Thread
Select distinct speed on an indexed columnNathan Cassano15 Sep
  • Re: Select distinct speed on an indexed columnJoseph Bueno15 Sep
  • Re: Select distinct speed on an indexed columnHaydies15 Sep
RE: Select distinct speed on an indexed columnNathan Cassano15 Sep
  • Re: Select distinct speed on an indexed columnJoseph Bueno15 Sep
RE: Select distinct speed on an indexed columnNathan Cassano15 Sep
RE: Select distinct speed on an indexed columnNathan Cassano15 Sep
RE: Select distinct speed on an indexed columnNathan Cassano15 Sep