how to optimize queries in general?
Posted 31 October 2003 - 06:33 AM
At the beginning I wrote a nested query and thought that it worked, after I ran it...I remembered that it was not a PostgreSQL DB....so I broke down the query into 3 queries with 2 loops.
However, the tables are too big(one has 200,000 rows, another has 20,000 rows, the last one has 6,000 rows), so the process takes about 2 hrs to complete on a LAN.
I just want to know, in general, how can I optimize select statements?
Posted 31 October 2003 - 07:29 AM
Hope that helps!
Posted 31 October 2003 - 08:18 AM
yea...indexing will help...but for each insert/delete, I have to pay for it since the index tree changes everytime I insert/delete. I am not sure whether it is worth...I will check with my database schema. Thanks.
Posted 04 November 2003 - 02:33 AM
Sometimes the need to mess with their heads ...
... outweighs the millstone of humiliation.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users