Re: Problem with multi-part keys

2001-05-03 Thread Bob Hall
>Hello All, > >I've bumped into a problem and can't figure out how to solve it. >If anyone has a spare minute to give me a hint on what's wrong >I'd apreciate it a lot! > >The problem is that when I add 'use index ()' >to my queries, MySQL doesn't always use the whole key, >but decides what left-m

Problem with multi-part keys

2001-05-02 Thread Alexander Paperno
Hello All, I've bumped into a problem and can't figure out how to solve it. If anyone has a spare minute to give me a hint on what's wrong I'd apreciate it a lot! The problem is that when I add 'use index ()' to my queries, MySQL doesn't always use the whole key, but decides what left-most part