kine
kine copied to clipboard
Superfluous index definition
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.
@mcekovic we welcome community PRs!