Processing the queue

When the queue is populated, the next step is to generate the index. This populates the PQSEARCHINDEX table with the spatial index information for items, occurrence threads, and appearance path nodes that are impacted by the bounding boxes. The spatial index is the rolled up bounding box of all children and all their revisions, as described in "Understanding spatial search indexes."

Starting from the bottom, the bounding box of the dataset (piece part), its transform then rolls up to its subassembly. Rolling up continues through the assembly structure, populating the information for each item. This process uses the QSEARCH_force_simplify_to_one_box method.

The PBOUNDINGBOX table and the PQSEARCHINDEX table are populated with the resulting entries.

After processing the queue, it is recommended that you regenerate the database statistics to improve search performance.