without the index on keywords.codice:
mysql show index from keywords;
+--++--+--+-+---+-+--++-+
| Table| Non_unique | Key_name | Seq_in_index | Column_name |
Collation | Cardinality | Sub_part |
Hi, I have the following tables :
CREATE TABLE articoli (
codice varchar(16) PRIMARY KEY,
descrizione varchar(255),
marca varchar(255) NOT NULL,
misure varchar(32),
peso
Hi!
nsabbi == nsabbi [EMAIL PROTECTED] writes:
nsabbi Hi, I have the following tables :
cut
nsabbi explain SELECT DISTINCT a.* FROM articoli a, keywords k WHERE a.codice =
nsabbi k.codice AND keyword IN ('tubo') GROUP BY a.codice HAVING
nsabbi count(k.keyword)=1 limit 1, 26;
nsabbi