hi,I have a ASA6.0.1 database which has two table stru_tab(620000rows) and
detail_tab(170000rows), I found a problem when I use T-sql to query these
two table use a left outer join where clause, but the question is some times
it just cost less 1 sec. but some times it could make a minute to display
query results, query T-sql is same but retrieve paraments is different,
Could you tell me why?
thank you for any words!
zjinshen@htc.net.cn