How to best partition a table and how will the query be
hi experts.
The developer is asking me how to best partition a table that has 30 millions records daily and how it will be the query.
They say that currently they are querying the column filedate which is a string, and then they look for a substring to look for the data by day. They don't use the index making the process more slow.
They want to create a column named FILEDATE_PARTITION and this to have a partition by day so to be able to filter by day and using a index so that it can be more efficient.
The developer is asking me how to best partition a table that has 30 millions records daily and how it will be the query.
They say that currently they are querying the column filedate which is a string, and then they look for a substring to look for the data by day. They don't use the index making the process more slow.
They want to create a column named FILEDATE_PARTITION and this to have a partition by day so to be able to filter by day and using a index so that it can be more efficient.
0