You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Just scanning through repo and found superfluous index definition in most of the drivers:
CREATE INDEX IF NOT EXISTS kine_name_index ON kine (name), // Superfluous CREATE INDEX IF NOT EXISTS kine_name_id_index ON kine (name,id),
First index 'kine_name_index' is superfluous as RDBMSes can use second one 'kine_name_id_index' efficiently when searching just by 'name'. Removing this index can improve noticeably Kine insert performance and search by name performance would not be affected.
The text was updated successfully, but these errors were encountered:
Just scanning through repo and found superfluous index definition in most of the drivers:
CREATE INDEX IF NOT EXISTS kine_name_index ON kine (name)
, // SuperfluousCREATE INDEX IF NOT EXISTS kine_name_id_index ON kine (name,id)
,First index 'kine_name_index' is superfluous as RDBMSes can use second one 'kine_name_id_index' efficiently when searching just by 'name'. Removing this index can improve noticeably Kine insert performance and search by name performance would not be affected.
The text was updated successfully, but these errors were encountered: