As noted. I want to know if my query is well optimized.
Yes, in Cassandra 1.2 you can enable trace request for requests.