This version of the Pivotal Greenplum documentation is no longer actively maintained. Click here to view the most up-to-date version of the Greenplum 4.x documentation.
The pg_amop table stores information about operators associated with index access method operator classes. There is one row for each operator that is a member of an operator class.
|amopclaid||oid||pg_opclass.oid||The index operator class this entry is for|
|amopsubtype||oid||pg_type.oid||Subtype to distinguish multiple entries for one strategy; zero for default|
|amopstrategy||int2||Operator strategy number|
|amopreqcheck||boolean||Index hit must be rechecked|
|amopopr||oid||pg_operator.oid||OID of the operator|