If cardinality is high (i.e large number of rows returned in the set for
your query), then mysql may need to resort to filesort.
- Ashish
2010/6/21 Octavian Rasnita
> Hi,
>
> I have made an InnoDB table and I am trying to search using some keys, but
> they are not used, and the query takes a ve
Hi Octavian, all!
Octavian Rasnita wrote:
> Hi,
>
> I have made an InnoDB table and I am trying to search using some keys, but
> they are not used, and the query takes a very long time.
>
> Here is a test table:
>
> CREATE TABLE `test` (
> `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
> `sym
Hi,
I have made an InnoDB table and I am trying to search using some keys, but they
are not used, and the query takes a very long time.
Here is a test table:
CREATE TABLE `test` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`symbol` varchar(20) NOT NULL,
`market` varchar(20) NOT NULL,
`id_sy
