While writing SQL queries can be challenging, ensuring that these queries are well-optimized and run efficiently is even more involved. The Query Assistant can help to apply optimization strategies to your queries, where possible.
Some queries are inherently expensive to run. The Query Assistant can help to tune your query, but sometimes accelerating a query further is not possible.
Finding the most expensive NFT ever sold
You have a (working) query to obtain the most expensive NFT sale of all time, in USD:
SELECT usd_price FROM ethereum.nft_sales ORDER BY usd_price desc nulls last limit 1
However, this query runs too slowly. You can ask the Query Assistant to optimize it for you. In the Query Assistant input box, write:
The following query is trying to get the most expensive NFT sale in history. SELECT usd_price FROM ethereum.nft_sales ORDER BY usd_price desc nulls last limit 1 Generate a significantly more optimized version
The Query Assistant outputs:
SELECT MAX(usd_price) FROM ethereum.nft_sales
Tips and Tricks
Learn some strategies to get the most out of the Query Assistant
Got questions? Join our Discord
Discord is the primary home of the Transpose developer community. Join us to ask questions, share your work, and get help.