explain.sql
All Users
Actions

Authored By

	epriestley
	Jul 26 2011, 1:14 AM

Size

703 B

Referenced Files

None

Subscribers

None

explain.sql
View Options

	mysql> EXPLAIN SELECT * FROM herald_transcript WHERE `time` < UNIX_TIMESTAMP() - (60 * 60 * 24) AND objectTranscript != "" LIMIT 100;
	+----+-------------+-------------------+------+---------------+------+---------+------+------+-------------+
	\| id \| select_type \| table \| type \| possible_keys \| key \| key_len \| ref \| rows \| Extra \|
	+----+-------------+-------------------+------+---------------+------+---------+------+------+-------------+
	\| 1 \| SIMPLE \| herald_transcript \| ALL \| NULL \| NULL \| NULL \| NULL \| 3766 \| Using where \|
	+----+-------------+-------------------+------+---------------+------+---------+------+------+-------------+
	1 row in set (0.00 sec)

File Metadata

Mime Type: text/plain; charset=utf-8
Storage Engine: amazon-s3
Storage Format: Raw Data
Storage Handle: phabricator/b7avcp2gtgponnvp2dso
Default Alt Text: explain.sql (703 B)

Event Timeline