Db2 query too fast!!
Posted on 2003-03-09
I need a db2 select query that takes a lot of time to execute. Any ideas on bad practices in db2 that will cause the database to really kill itself (in the order of minutes). I have a million records in 1 table which is refrenced in 3 different tables.
I know like's take time. Also not's. What about group by's and sort's etc etc etc.
Help!! Anything you did to speed up your db2 select query tell me so I can do the opposite.