My question regards the use of indexes to improve the speed of data retrieval.
We are building an application where users aggregate their banking transactions.
Our schema connects a table
User (one) to a table
To improve the speed of the data query, we would like to index the
Transaction table on
However, unless I am mistaken, at the moment, we cannot index a table of the ID of another table.
To solve the problem, my first instinct would be to create a
userId field on the
Transaction table and perform the indexing on this new field.
Is this the right approach to the problem?
Would you have another solution to propose?