You can inspect an environment's queries to understand their efficiency.
From the VantageCloud Lake Console navigation panel, select Queries. Click Connect to provide credentials to connect to the environment of your choice.
With the appropriate query privileges, you can do the following:
- View details about current or completed queries for all users. This includes implicit queries, which run in the background.
- Drill down to inspect the steps of a query.
- Copy or download SQL statements.
- Compare the performance of alternative code to develop more efficient processing strategies.
- Monitor both current and completed queries within a selected time frame within a single unified view.
- Cancel current queries for any user.
You can also monitor queries using system views. See Monitor Queries.