Man, I feel like such an idiot. I didn't realize that's what my code looked like. When I saved it, it was "well defined".

Lesson learned. Thanks!

Jeff Moden (3/18/2008)

---

Lynn Pettis (3/17/2008)

---

I have looked at the two files with CREATE Table statements, and I'm not going to do anything with those as it is too hard to...

GSquared (3/18/2008)

Usually, building OLAP cubes doesn't require fast queries. Or does Cognos not persist the cube as a separate object? If you're loading data into OLAP cubes, the...

99% of the time, the same fields are used in my order/where/join clauses. It sounds as though "include" may help out quite a bit.

Also, I created indexes on my two...

Thank GSquared! I really appreciate your help.

If I could ask another question?

These queries will be used as data sources to build OLAP cubes (Cognos Transformer). Depending on which cube...

Hi,

Just to add to my existing post. The following query takes less then 2 minutes to complete. If I remove the index hints, it takes over 40 minutes.

[font="Courier New"]select...

Sorry about that Lynn. Hope these attachments are OK.

Thanks for the help and sorry for posting in the incorrect section.

Table A (ih_hist) currently has 3,656,530 rows. Table B (idh_hist) has 61,206,053. If I run the query with a...