NAME
DBIO::Informix::Introspect::Indexes - Introspect Informix indexes
VERSION
version 0.900007
DESCRIPTION
Fetches index metadata via sysindexes. The index-to-column link is sysindexes.part1 .. part16, each a syscolumns.colno of the same table; a negative part is a descending column (the absolute value is the column number), 0 is unused. Columns come out in part order.
Measured against Informix 15.0.1. Not handled: functional / opaque-type indexes (whose parts do not name plain columns). Indexes the server created for a constraint (named like " 136_41", listed as sysconstraints.idxname) are left out: the primary and foreign keys are modelled as such, and the names differ from one database to the next, so diffing them by name would drop and recreate them.
METHODS
fetch
my $indexes = DBIO::Informix::Introspect::Indexes->fetch($dbh, $schema, $tables);
Returns a hashref keyed by table name. Each value is a hashref keyed by index name, with keys: index_name, unique, columns.
AUTHOR
DBIO & DBIx::Class Authors
COPYRIGHT AND LICENSE
Copyright (C) 2026 DBIO Authors Portions Copyright (C) 2005-2025 DBIx::Class Authors Based on DBIx::Class, heavily modified.
This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.