I've created a report that will bring back customer's that only have 1 insurance policy and the details of that policy. In order to do this I had to add a condition (subquery) that checks to see that a particular customer truely has ONLY 1 policy first. The report is taking a terribly long time to run in full client and it doesn't return anything in WebI but "page cannot be displayed". Any suggestions?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
When to use subqueries?
- Thread starter amil130
- Start date
My suggestion would be to take the SQL that the dataprovider generates and take that to the DBA for testing.(explain plan).
Without having a look at the SQL itself it is impossible to judge where the bottleneck is. Your DBA will be able to tell you why the performance is so low (and possible remedies)...
T. Blom
Information analyst
tbl@shimano-eu.com
Without having a look at the SQL itself it is impossible to judge where the bottleneck is. Your DBA will be able to tell you why the performance is so low (and possible remedies)...
T. Blom
Information analyst
tbl@shimano-eu.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question