On Mon, Nov 5, 2012 at 10:53 AM, Maxim Veksler <ma...@vekslers.org> wrote:
> Are indexes on composite column supported ? > Index on any part of the PRIMARY KEY is not supported (whether the PRIMARY KEY is composite or not btw), not yet at least. > If not, a suggestion for a work around? > In your case, you're asking for an index on the first component of the PRIMARY KEY, which is non-sensical in the sense that this component is already always "indexed". If you want all the rows whose campaignId = 3, just do SELECT FROM userinfo2 WHERE campaignId = 3. -- Sylvain
