MySQL Forums
Forum List  »  Newbie

Re: SELECT took lengthy of time
Posted by: Shawn Taylor
Date: August 24, 2010 01:15PM

What is the cardinality of the airdate index. Can you provide some sample data from the table?


Also, post back the following please:

Show Table Status 'stationlog';
show create table 'stationlog';

Shawn

Options: ReplyQuote


Subject
Written By
Posted
August 23, 2010 07:23PM
August 23, 2010 09:51PM
Re: SELECT took lengthy of time
August 24, 2010 01:15PM
August 24, 2010 09:26PM
August 26, 2010 07:05PM
August 26, 2010 10:05PM
August 28, 2010 05:42AM
August 29, 2010 10:20PM
August 23, 2010 11:56PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.