On 5/22/23 01:53, Phani Prathyush Somayajula wrote:
>
> Hi All,
>
> 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).
>
[snip]
>
> 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.