Abstract: Technologies are disclosed for indexing and searching using a single table index. A processing device receives a query and processes a global index associated with a database with respect to the query to identify corresponding identifiers and/or strings, processes indexes associated with data items within the database with respect to the identifiers and/or strings, scans adjacent rows in the index that include identifiers and/or strings, identifies identifiers that are associated with the identifiers and/or strings, scans rows of the indexes to identify additional rows that also include the other identifiers, identifies search results in response to the query, prioritizes the search results based on priority status indicators associated with the search results, and provides the search results, as prioritized, in response to the query.

Abstract: Systems and methods are disclosed for indexing and searching using a single table index. A processing device receives a query and processes a global index associated with a database with respect to the query to identify corresponding identifiers and/or strings, processes indexes associated with data items within the database with respect to the identifiers and/or strings, scans adjacent rows in the index that include identifiers and/or strings, identify identifiers that are associated with the identifiers and/or strings, scan rows of the indexes to identify additional rows that also include the other identifiers, identify search results in response to the query, prioritize the search results based on priority status indicators associated with the search results, and provide the one or more search results, as prioritized, in response to the query.