You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by Akash <ak...@iiitb.net> on 2011/01/14 09:33:21 UTC

Query

Hi,

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

Thnkas and regards,
Akash

Re: Query

Posted by "Dag H. Wanvik" <da...@oracle.com>.

Akash <ak...@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