[CDB] Implement Transaction 2.8 - Related-Customer

CS4224-Claps / project

MIT License

1 stars 0 forks source link

[CDB] Implement Transaction 2.8 - Related-Customer #14

Closed benclmnt closed 3 years ago

benclmnt commented 3 years ago

This is a literal translation of the requirement and runs very slowly (~5s)

benclmnt commented 3 years ago

An idea to improve the performance of this query is to store an additional array of I_IDs in Order table, create an index of (O_W_ID, O_D_ID, O_C_ID) STORING ([I_ID]) and then count the array length of the similar item_ids is >= 2