Re: Slow Queries : Using Temporary , Using Filesort

[Rick James]

Query 2:

SELECT  o.id, o.title, o.desc, o.uid, o.keyword,
        o.comp
    FROM  uniqueproducts o
    INNER JOIN  mem_pack m ON o.uid = m.uid
    WHERE  o.approv = 1
      AND  m.type = 3
      AND  match(o.title , o.keyword ) against ('+shirt +and +trouser/jeans' in boolean mode)
    GROUP BY  o.uid
    ORDER BY  o.date ASC, o.id ASC
    LIMIT  0, 10;

You need this for FULLTEXT to kick in:
FULLTEXT(title, keyword)

KEY `uid` (`uid`),
Where's the field? It seems to be NULLable? Should it be?