SQL Query Performance

jasonkwp

Good day all

I am joining Navision tables to get a certain result

firstly I am analyzing the values in the value entry table for a specific customer in NAV vs my OLAP Cube report and the values do match , my analysis will be done in Tableau later.

So in order for me to get the Sales Invoice Line and Sales Cr_Memo data together I have inserted the data from both tables into one SQL table. Then I took the customer table and Value entry table to join to the new table I have created , however my query runs very long , how can I optimize the query to run faster in less time

Peter+is1

hi,

Have you created any indices on your new table?

kylehardin

Rather than creating a new SQL table that has the combined results of invoice line and cr memo line, why not use a regular SQL join? You can either do it with a select statement, or you can create a SQL view that does the join for you.

Peter+is1

hi,

Have you created any indices on your new table?