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

[Tim Tao]

Hi ODB support,


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? To me this index seems useless since the subtable already has an index on its parent table's primary key.


Looking forward to your reply


Thanks!

________________________________
[http://www.akunacapital.com/images/akuna.png]
Tim Tao | Junior Developer

| www.akunacapital.com <http://www.akunacapital.com>
p: | m: | f: | tim.tao at akunacapital.com

Please consider the environment, before printing this email.

This electronic message contains information from Akuna Capital LLC that may be confidential, legally privileged or otherwise protected from disclosure. This information is intended for the use of the addressee only and is not offered as investment advice to be relied upon for personal or professional use. Additionally, all electronic messages are recorded and stored in compliance pursuant to applicable SEC rules. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, printing or any other use of, or any action in reliance on, the contents of this electronic message is strictly prohibited. If you have received this communication in error, please notify us by telephone at (312)994-4640 and destroy the original message.