> Just I want to know why heap size increase on query execution? If any body technically explain it will be better. Is there method to free it? See Ryan's post (#11) and read the doc he linked. Your questions are answered there, so there is no reason to write the same out here.