[odb-users] Index on subtable column "index"

[Boris Kolpackov]

Hi Tim,

Tim Tao <Tim.Tao at akunacapital.com> writes:

> I got a question about ODB subtable, so when we declare a container, 
> e.g vector, in an ODB object, it will create a subtable for this 
> container and a new column "index" with it, which is a very good
> design I think, but I am wondering why ODB will also add an index
> on this "index" column, is there any performance consideration?

Yes, the SELECT statement that loads the elements of the container,
has the 'ORDER BY index' clause.

Boris