Re: Another newbie question
Posted by:
Rick James
Date: February 27, 2014 08:47PM
> Is the index "fx_QSO_User_idx" adding any value? Will the system be able to exploit the clientID field in the other two indexes?
No; Yes. That is a rephrasing of what I said.
But note... It can 'exploit' only because it is a 'prefix' of some other index. That is:
INDEX(a), INDEX(a,b) -- toss INDEX(a)
INDEX(b), INDEX(a,b) -- don't toss INDEX(b) since `b` does not come first in (a,b).
> I have added the index "Mine" ... The index obviously helps a lot.
> KEY `Mine` (`clientID`,`BAND`,`MODE`,`DXCC`)
But it does not look any different??
Subject
Written By
Posted
February 06, 2014 11:58PM
February 07, 2014 01:11AM
February 07, 2014 06:41AM
February 07, 2014 11:15AM
February 07, 2014 07:50PM
February 08, 2014 11:54AM
February 08, 2014 05:41PM
February 08, 2014 06:55PM
February 08, 2014 06:59PM
February 08, 2014 08:48PM
February 09, 2014 02:56AM
February 09, 2014 07:43PM
February 10, 2014 02:31PM
February 11, 2014 05:10AM
February 11, 2014 10:41AM
February 11, 2014 08:12PM
February 12, 2014 12:50AM
February 12, 2014 08:32AM
February 12, 2014 07:39PM
February 12, 2014 10:47PM
February 12, 2014 11:50PM
February 13, 2014 12:00AM
February 13, 2014 02:14AM
February 13, 2014 11:10PM
February 16, 2014 12:51AM
February 27, 2014 04:54AM
Re: Another newbie question
February 27, 2014 08:47PM