I’ve a table ermabet having 80mil records. My business need is to check the bet placed by a player(users), which queries the table, and enable streaming for the player only if he has placed his bet in the last 24 hrs( granular to the millisecond).
But I don’t want PLACEDON column part of the primary key.
And I didn't want partition_date in my PK, either, but I had to add so as to partition on the part_date column.
Born in Arizona, moved to Babylonia.