Challenge: Rewrite query to use indexed field

- In this Challenge, you'll be asked…to examine the following SOQL query statement,…using the Query Plan tool in Developer Console.…The statement should return all open Opportunities,…or those that are not closed.…And as you can see,…you have some results here in New Query Results,…and it should produce a total of 31 rows.…And you should be getting the same result in your org.…For this Challenge, what I want you to do…is to start by executing the query,…and also examining the query plan.…

Make sure you notice the cost of the query.…Identify what changes you think could be made…to this query, so it will have a lower cost.…Go ahead and make those changes,…and then evaluate the results…using the Query Plan tool.…Keep in mind that there may be multiple ways…to perform this same query.…This Challenge should only take about…10 minutes to complete, and when you're done,…make sure to check out my Solution video,…where I'll show you what I did…to make the query more efficient.…