Skip to Content
0
Apr 21, 2009 at 01:30 PM

SQL query execution in DB02 hangs if record set is more than 50000

259 Views

Hi,

We are facing issue in a report performance. The return is using native SQL query.

There are custom views created ar database level for pricing/maetrial and stock. The native sql query is written on these views. The report takes around 15 mins to run in background .

We are trying to analyse the native SQL query through DB02. I tried fetching records for one particular

custom view to make out if its indexing issue or something else.When i using TOP 35000 records with select query runs fine with this dataset or less than this . If i increase it to 40000 system doesn;t show anything in SQL ouptut. And above one lakh records system gives timeout.

The count in this view gives some 10 lakh records which I don't feel is v.v.huge that query that too native sql takes so much time.

Any help on this will be highly appreciated.

Regards

Madhu