Hypothetical indexes in PostgreSQL 9.0

License: Free ‎File size: N/A
‎Users Rating: 5.0/5 - ‎1 ‎votes

ABOUT Hypothetical indexes in PostgreSQL

Hypothetical indexes are simulated index structures created solely in the database catalog (not physically). We have made some server extensions to PostgreSQL and introduced 3 new commands: create/drop hypothetical index and explain hypothetical.