I searched the archives but didn't come across anything like my problem I have a table with 2 indices, the primary key that is an auto_increment, and a datetime field. when I do a show index It displays the primary key first and the story date index second. When I run myismchk --sort-result=2 on the table it takes a good long time (table has 26,000) right now, but when it's done, if I so a select * from table the result list still comes to the screen in order of the primary key. This leads me to beleive that the rows were not sorted, but I just want to doublecheck. The second reason I don't think it's sorting. Is that my date range searches haven't gotten and faster. >From all I've read it seems that my indices are good, and work good when joining other tables. But if the records were in order I should get better preformance. The table is named story, and here is the output from show index from story. mysql> show index from story; Table|Non_unique|Key_name|Seq_in_index|Column_name|Collation|Cardinality|Sub_part|Packed|Comment| story|0 |PRIMARY |1 |story_id |A |26446 |NULL |NULL | | story|1 |story_date|1 |story_date |A |244 |NULL |NULL | | any help would be greatly appricaited. -- Jeff Bearer, RHCE Webmaster PittsburghLIVE.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
