| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Corin Langosch | Date: | December 9 2003 9:11am |
| Subject: | key is not used | ||
| View as plain text | |||
Hello, i'm having a problem with mysql. when i put an index on a datetime column, it's never used. for example the sql: 'EXPLAIN SELECT * FROM actions ORDER BY datum' shows: table type possible_keys key key_len ref rows Extra actions ALL NULL NULL NULL NULL 75853 Using filesort even if i use the sql: 'EXPLAIN SELECT * FROM actions USE INDEX (datum) ORDER BY datum' mysql doesn' use the index :-(( tahnks for any help, corin
| Thread | ||
|---|---|---|
| • key is not used | Corin Langosch | 9 Dec |
| • Re: key is not used | Martijn Tonies | 9 Dec |
| • Re[2]: key is not used | Corin Langosch | 9 Dec |
| • Re: key is not used | Chuck Gadd | 9 Dec |
| • update: key is not used | Corin Langosch | 9 Dec |
| • Re: update: key is not used | Egor Egorov | 9 Dec |
| • Re: Re[2]: key is not used | Martijn Tonies | 9 Dec |
