Re: Indexes are not working after restoring dump

[Amit K]

Posting additional information.
+-------------------------+------------------------------------------------------------------------+
| Variable_name | Value |
+-------------------------+------------------------------------------------------------------------+
| innodb_version | 5.5.37-35.0-35.0 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.5.37-35.0-log |
| version_comment | Percona XtraDB Cluster (GPL), Release 35.0 (Ubuntu), wsrep_25.10.rXXXX |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
+-------------------------+------------------------------------------------------------------------+

###Sample Query, using subquery to filter the data

Select id from t1 where t1.c1 IN (select t2.id from t2, t3
where t2.c2 = t3.id and t3.id = 33288 and t2.c3 = 0 )