Home / Tableau Software Articles / Improving Database Query Efficiency

Improving Database Query Efficiency


At the heart of developing well-performing workbooks and visualizations is the fundamental principle that the visualization will never ever run faster than the underlying inquiry. Consequently, to make certain a workbook is running as quickly as feasible you have to make sure the question is running ideally.

Know exactly what you are inquiring about

The time it takes the database management system (DBMS) to compute the results, after that stream the documents back to Tableau can be significant. If this number is quite huge, you are potentially pulling a big amount of information from the data source.

Guarantee you are not including any type of unnecessary dimensions in your visualization – this will certainly impact the aggregations in the data source and also enhance the dimension of the outcome collection.

Use native drivers

Tableau items include the capacity to attach to a wide range of information resources. A number of these data sources are applied as indigenous connections which suggest Tableau has actually executed methods, capacities and also optimizations particular to these information sources. Tableau design as well as screening tasks for these connections ensure they are one of the most durable Tableau has to provide.

Tableau has actually additionally executed the choice to make use of the general-purpose ODBC standard for accessing data resources beyond the list of called choices available when creating a brand-new link. As a publicly specified standard, lots of data source vendors make ODBC drivers offered for attaching to their databases. Tableau supplies the alternative to use these ODBC vehicle drivers to connect to data.

There can be distinctions in exactly how each data source supplier analyzes or applies capabilities of the ODBC standard. Sometimes Tableau will certainly recommend or need you to produce a data essence to continue working with a specific vehicle driver. There will likewise be some ODBC drivers and also data sources that Tableau is incapable to link to.

If there is an indigenous vehicle driver for the information resource you are quizing you must utilize this over the ODBC links as it will typically offer much better performance.

About admin

Check Also

Tableau Software Soars

Data company Tableau Software program reported 3rd quarter earnings after the bell on Thursday, uploading …