Article:  |
Introducing SQL Sets | |
| Subject: | Doubt in union operator | |
| Date: | 2001-10-09 20:23:15 | |
| From: | suresh175 | |
| We are using UNION operator for getting the result from 2 sql statements. If one of the sql statements returns zero rows, then whole sql statement almost hangs, i.e. it takes more than 2hrs. If both the sql statement returns value it takes less that an minute. Could you please provide as the reason why it is so ? | ||
Women in Technology
Hear us Roar
