This article reviews how to modify an SQL query to group related rows together to provide summary statistics database information and introduces the concept of a view, which can be used to simplify database application development by creating a virtual table that represents the results of an SQL query. Also learn about database indexes, which you can use to locate specific table rows. After you’ve mastered these advanced database concepts, you’ll be well positioned to begin developing Java database applications with Apache Derby.
Developing with Apache Derby – Hitting the Trifecta
Submitted by BlueVoodoo 2006-11-13 General Development 3 Comments
A view? how novel. really. shesh. While we are at it, lets create an index.
Views, Group By and Indexes are advanced?