Hi Lets say we have two queries on the same table TAB1 (COL1 , COL2 ,COL3) as SELECT * FROM TAB1 SELECT COL1 FROM TAB1 Isn't it make sense to use the cached cursor of first query. What could be possible drawbacks .. other than having a less efficient query plan , wouldn't it be really efficient for tables less than say 1000 rows. I would like to add such a feature in derby. Any suggestions please....
-- Vipul Modi MSc.(Tech) Information System BITS-Pilani Goa Campus
