A database index might improve the performance of a query that searches for a list property value.
Content Platform Engine SQL | Corresponding database SQL (continuable query) |
---|---|
|
|
By default, tables in the Content Platform Engine of the form object store of the form "ListOf<Table>" are not indexed for user searches. (But a system index exists that supports retrievals of values for a specific object.) The <Table> can designate String, Boolean, Integer32, Float64, Datetime, or Id.
CREATE INDEX I_LOS
ON ListOf<Table> (element_value, parent_prop_id, parent_id)
CREATE INDEX I_LOS
ON ListOfString (lower(element_value), parent_prop_id, parent_id)