Q&A BY TAG 'Sql performance'

You must sign in to ask a question. If you do not have an account, you can register here

WHERE Clause in query
answered 10-01-2018 14:12:41 -0500

I have created dervied view's using Baseview views and query also has an where clause at the end on one the Base view. When I run the new derived view the where condition is executed at the end. I dont see this helping peformance. please let me know, I...

Answers: 1

query plan Sql performance WHERE CONDITIONS

Performance Bench Marks
answered 10-01-2018 09:27:29 -0500

I'm currently seeing performance issues when we run quiries extracting data from tables with multimilliion records. The data movement is slow and cpu consumption is quite high during the query execution. As a first step, I would like to compare it to t...

Answers: 1

performance Bulk Data Load Sql performance

SQL queries ran on native Data source in VDP
answered 29-08-2017 10:30:36 -0400

Hello there, I just a few questions, I was wondering if you could provide me with an answer. How can I edit a SQL query that I created directly on the Data Source(Hadoop)? How should the SQL query be written, names the datasource, table, and fiel...

Answers: 1

base view Hadoop Sql performance derived view

Using NOLOCK hint in VQL Select statement
answered 20-01-2017 05:51:47 -0500

Is it possible to use NOLOCK hint in select statement on SQL Source

Answers: 1

VQL Sql performance SQL Server

Slow performance when joining tables from oracle database
answered 28-11-2014 05:48:16 -0500

Two issues related to vql performance. I am connecting to a oracle 12c database and trying to query a record from huge table. Denodo is not returning records . I am testing joining two oracle tables using the base views . The performance of the query ...

Answers: 3

oracle Sql performance