Viewing the SQL Query Plan of a Table
To view the SQL statements that a table will attempt to execute (the query plan), right-click the title bar, and select ‘Show Plan’ from the context menu. This opens the ‘Query Plan’ dialog box.
The ‘Query Plan’ dialog box displays the queries that will be sent to the database at runtime. Additionally, it shows the data operations that the Worksheet will perform in post-processing, after the data is retrieved from the database.
By default, the Worksheet attempts to create a single SQL query that fully generates the table’s data. This is typically the most efficient approach because it allows the database to perform all the needed data operations (joins, filtering, etc.). However, you can override this behavior for a particular table by deselecting the ‘Merge SQL’ option in the ‘Table Properties’ dialog box.
| #1 Ranking: Read how InetSoft was rated #1 for user adoption in G2's user survey-based index | Read More |
Example: Viewing the SQL Query Plan
This example illustrates how you can control the SQL query that a table sends to the database.
- Expand the ‘TABLE’ > ‘SA’ node of the ‘Orders’ data source.
- Drag the ‘PRODUCTS’ table to an empty location on the Worksheet.
- Drag the ‘CATEGORIES’ table to an empty location on the Worksheet.
- Drag the ‘CATEGORY_ID’ column header from the ‘CATEGORIES’ table onto the ‘CATEGORY_ID’ column header of the ‘PRODUCTS’ table, and release when the ‘join’ symbol appears. This creates a new table called ‘Query’ that contains the inner join between the two tables based on the ‘CATEGORY_ID’ columns. (See Inner Join for more details.)
- Right-click the title bar of the ‘Query’ table, and select ‘Show Plan’. This displays the ‘Query Plan’ dialog box.
More Articles About Querying
Building Permits Reporting Software - The Municipal Department of Building Permits and Inspections typically employs various key performance indicators (KPIs) and metrics to evaluate the efficiency, effectiveness, and compliance of its permitting and inspection processes. These metrics help assess the department's performance in managing construction activities, ensuring regulatory compliance, promoting public safety, and supporting economic development. Here are some common KPIs and metrics used by such departments: Permit Processing Time: Average Permit Turnaround Time: The average time taken to review and approve building permit applications, from submission to issuance. Time to First Review: The time elapsed between receiving an application and conducting the initial review...
Geographic Mapping Analytics - A Franchise Performance Marketing Manager at a car rental company plays a crucial role in driving business growth and ensuring the success of individual franchise locations. Geographic Mapping Analytics is an invaluable tool for them, allowing them to make data-driven decisions to optimize marketing efforts and increase profitability. Here's a detailed explanation of how they might utilize this tool: Market Segmentation and Targeting: The manager can use geographic mapping to divide the market into segments based on location, demographics, and behavior. This helps in understanding which areas have the highest demand for car rentals...
How Do Executive Dashboards Work? - Executive dashboards are personalized user interfaces that provide your company's data graphically and in an orderly fashion. You may gather data using executive dashboards to monitor team objectives, make adjustments, spot patterns, forecast outcomes, and more. Your executive dashboards promote strategic decision-making by showing the most important facts for your business in real time, eliminating the need for further, pointless research. Executive dashboards provide: A user-friendly graphical interface Metrics that may be changed to suit your requirements Information gathered from many sources and agencies A system that makes it simple to get current information...
Law Enforcement Report Tool - Temporal Analysis: Use the tool to conduct temporal analysis, examining how certain events or activities change over time. Generate timelines or heat maps to visualize temporal patterns and correlations. Geospatial Analysis: Leverage geospatial capabilities to map crime locations, identify hotspots, and analyze spatial relationships. Overlay additional contextual data, such as demographic information or known criminal associates, to enhance understanding. Pattern Recognition: Apply analytical models and algorithms within the custom report tool to identify patterns, anomalies, or trends that may not be immediately apparent. Explore relationships between variables and entities to uncover hidden connections...
Management Organizational Culture - There are those things that are somewhat intangible. There are skills and knowledge within the organization that you have to look at. There is the management organizational culture and then last not least there are technologies, the software. I have worked with many organizations that have spent hundreds of million of dollars putting work management system and enterprise resource management systems in place, only to find out that the tool itself doesn't solve the problem. The tool will automate the problem. It will create problems much faster at a much faster rate, but it will not solve a problem...
This Year's Top Web Application Reporting Tools - An effective BI solution combines state of the art performance with accessibility. Whether you're a traveling executive or a work from home employee, you still need access to valuable, real-time information. InetSoft's Style Intelligence offers web-based reporting tools so that your users can access corporate information regardless of where they are. Having BI accessible via the web is essential in order to measure your KPI's in real-time and make sound decisions. InetSoft's BI platform allows you to interact with dashboards on the web, observing changes in data in real-time. Web based BI also allows for mobile use across several platforms. With InetSoft, you have access to dashboards and reports through a variety of web-based devices, including Android-based tablets, smartphones, iPads, and iPhones...
Why Is a Dashboard for Education Important? - For a number of reasons, educational institutions need an education dashboard. They are able to: Monitor and improve student performance: Education dashboards assist schools and institutions in keeping track of their students' academic achievement, identifying areas for development, and creating plans to improve student performance. Detect and resolve student behavior problems: Education dashboards assist schools in recognizing and resolving student behavior problems. Schools may intervene early and stop undesirable conduct from having an impact on academic achievement by measuring measures like attendance, tardiness, and disciplinary actions...
| Previous: Creating Sub-queries with SQL |