A user reports that a query run against the orders Explore takes a long time to run. The query includes only fields from the users view. Data for both views is updated in real time. The developer runs the following query in SQL Runner and quickly receives results:

SELECT * FROM users.

What should the developer do to improve the performance of the query in the Explore?

A. Create an Explore with users as the base table.

B. Create a persistent derived table from the user’s query.

C. Create an ephemeral derived table from the user’s query.

D. Add persist_for: “24 hours” to the orders Explore.

Reference: https://docs.looker.com/data-modeling/learning-lookml/sql-runner