Stuff

mysql> EXPLAIN SELECT *
    -> FROM myplay_import.cps_artist_news
    -> WHERE news_id >0
    -> AND artist_id =1034
    -> ORDER BY news_id 
    -> ;
+----+-------------+-----------------+------+-------------------+-----------+---------+-------+------+-----------------------------+
| id | select_type | table           | type | possible_keys     | key       | key_len | ref   | rows | Extra                       |
+----+-------------+-----------------+------+-------------------+-----------+---------+-------+------+-----------------------------+
|  1 | SIMPLE      | cps_artist_news | ref  | news_id,artist_id | artist_id | 3       | const |    1 | Using where; Using filesort | 
+----+-------------+-----------------+------+-------------------+-----------+---------+-------+------+-----------------------------+
1 row in set (0.00 sec)