Re: Partial key
noudshoorn wrote:
> I explain it to you:
I really would like to see the output of the commands
DESCRIBE yourtable;
SHOW INDEX FROM yourtable \G
EXPLAIN SELECT .... \G
> the table has now 12 rows.
You should test your queries on real data. MySQL might not bother using indexes with only 12 rows of data.
--
felix
Please use
BBCode to format your messages in this forum.
Subject
Views
Written By
Posted
3588
June 11, 2005 12:03PM
1833
June 14, 2005 10:42AM
1959
June 14, 2005 02:16PM
1699
June 15, 2005 02:21AM
1702
June 15, 2005 05:16AM
Re: Partial key
1854
June 15, 2005 06:24AM
5055
June 15, 2005 12:06PM
1758
June 16, 2005 05:07AM
1736
June 16, 2005 07:57AM
1731
June 16, 2005 08:30AM
1786
June 16, 2005 08:50AM
1638
June 16, 2005 10:21AM
2746
June 16, 2005 03:00PM
1730
June 17, 2005 12:00AM
1652
June 17, 2005 01:28AM
1635
June 20, 2005 01:21AM
1825
June 20, 2005 06:41AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.