MariaDB - fdlGitHub/ServiceNow GitHub Wiki
This page is a draft...
Examples Task table is alone and contains all records for incident, change requeest, problem, etc... Queries on task table are like: SELECT * FROM task WHERE sys_class_name = 'incident' (AND other conditions) (AND sys_domain_path conditions)
New Query How ^NQ is applied on database level? Need to be determined
Index limitation InnoDB (service in front of MariaDB) is limiting the quantity of indexes to 64 with the version 10.2 It could be up to 128 indexes authorized with an upper version (starting with at least v 10.4)
Index usage ServiceNow tables are configured as BTREE. Thanks to this configuration, InnoDB is checking the where condition to see which indexes can be applied and which index will be apply for a given query There is no prediction possible from application point of view.
Order By and Group By Order By and Group By action should be performed on indexed fields
Index are done as BTREE type. That means, indexes are used with the >, >=, =, <=, < or BETWEEN operators, as well as for LIKE comparisons that begin with a constant.
Needs confirmation but looks like we can do 'field1, field2' and 'field2, field1' as indexes.
Task: sys_class_name,number sys_class_name,active active,sys_class_name,number sys_class_name,a_ref_1,state,opened_by sys_class_name,a_ref_1,a_ref_5 sys_class_name,a_ref_1,sys_created_on sys_class_name,state,expected_start