Sql query optimization

Question

Question

Kumaresan R · Dec 2, 2017

#Object Data Model #Performance #SQL #Caché

We have 1lakh records in table and while using sql select statement , it is taking more than 9mins to 12 mins to get the records. could you please how to optimize this performance issue if we have more records. how to optimize it.

Discussion (3)1

Log in or sign up to continue

Gerd Nachtsheim · Dec 2, 2017

I fear you will have to give us more information before a helpful advice can be given.

what is the table definition?
how do the statistics (selectivities) look like?

And last not least

which SQL do you want to improve and how does the query plan look like?

0 0

score 0 · Answer 1 · 2017-12-02T12:32:00-05:00

It would be better if you can add your SQL query, and if it is not a secret also Classes definition. So, we could see if something may be wrong with it. And you also should look at the book in the documentation about SQL Optimizations.

score 0 · Answer 2 · 2017-12-04T04:50:49-05:00

Kumaresan, I have removed the "Developer Community FAQ" tag which is intended for use on posts about the DC software itself. I have added the "SQL" and "Performance" tags.