db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dag.wan...@oracle.com (Dag H. Wanvik)
Subject Re: Query
Date Sat, 15 Jan 2011 00:30:15 GMT
Akash <akashkumar.agrawal@iiitb.net> writes:

> What all index types can be used in Derby. Can i include my own index in the
> code.

Only normal B-tree indexes, unique and non-unique. Generated columns can
be used to alleviate the lack of ability to index on expressions.

http://db.apache.org/derby/docs/10.7/ref/rrefsqlj20937.html
http://db.apache.org/derby/docs/10.7/ref/rrefsqlj37836.html

> Can i have custom datatypes in Derby.

In a limited form, yes, cf.
http://db.apache.org/derby/docs/10.7/ref/rrefsqljcreatetype.html

Hope this helps,

Dag

Mime
View raw message