I've got one of the queries down to 67 seconds execution time.<BR><BR>I'm pretty happy with that.<BR><BR>I'll let the DBA slap some indexes on them tables and we are good to go.<BR><BR>I still have another few hours of query writing left before I crash.
I've got to release the reports part of this app. by COB Monday. I lost 2 days to a f*cked up query because I can't figure out how to do a right join on 2 fields on a table.<BR><BR>Sql Server is simple:<BR>SELECT T1.Field, T2.Field<BR>FROM Table1 T1<BR> RIGHT JOIN T2 ON (T1.FieldA = T2.FieldA AND T2.FieldB = T2.FieldB)<BR><BR>Stupid Oracle.<BR><BR>And then, I lost Friday because the Oracle server was down because someone restarted the Linux machine it's running on. Not a big problem, no? Well, it isn't in the start-up. And, the only person that knows how to start Oracle (and is also the only person that knows password to the box) was out for the day.<BR><BR>Bleh.<BR><BR>So, I got to the office about 4:00pm on Sunday and have been working since.