Developer - Query works fast in my environment but is slow in production?

Database perspective matters than the developers. :)

Generate a Query execution plan to understand the execution plan chosen by the database optimizer.

An execution plan (Explain plan) helps to understand:

1. Number of rows examined
2. Use of indexes
3. Missing indexes
4. Type of join
5. Information on sorting, etc