Importing Directed Queries
After you determine which exported query plans you wish to use in the current database, you import them with IMPORT_DIRECTED_QUERIES
. You supply this function with the name of the export file that you created with EXPORT_DIRECTED_QUERIES
, and the names of directed queries you wish to import. For example:
=> SELECT IMPORT_DIRECTED_QUERIES('/home/dbadmin/outputQueries','FindEmployeesBoston'); IMPORT_DIRECTED_QUERIES ------------------------------------------------------------------------------------------ 1 directed queries successfully imported. To activate a query named 'my_query1': =>ACTIVATE DIRECTED QUERY 'my_query1'; (1 row)
After importing the desired directed queries, you must activate them with ACTIVATE DIRECTED QUERY
before you can use them to create query plans.