Two subqueries

building reports webintelligence
1

hello all,

I have 2 subqueries ANDed and it looks perfect if i see the output but it hampers the performance and sometimes doesn’t come out, so is there any way out to have the same result set with improved performance.

Please suggest.

Thanks

lahca_ac (BOB member since 2010-01-18)

2

Any views please…

Thanks

lahca_ac (BOB member since 2010-01-18)

3

Just same general answers:

  • Get your DBA involved in tuning the SQL statement
  • Look at proper indexing at the DB level, including updating statistics at the database
  • Look at avoiding sub-queries (maybe you can use ETL to pre-calculate stuff)

Andreas :de: (BOB member since 2002-06-20)