I am preparing myself for v9.7, especially local indexes for my table-partitioned tables. I understand that an index is only "local" when the column on which the partitioning was based, is included in the index itself.
Well, I am using a TIMESTAMP column so I wonder if I can use a generated column (based upon the values of the same TIMESTAMP) and still have a local index.
Does anyone know, or in the position to test it for me?
(on my express-C I can try & test anything, except table partitioning)
