db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From vipul modi <vipul.1...@gmail.com>
Subject A small query related to database concepts.
Date Fri, 24 Dec 2010 05:40:33 GMT
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

Mime
View raw message