Should We choose Bigint instead of int In our Database table? -

Should We choose Bigint instead of int In our Database table? -

i'm curious should must take bigint primary key id in our datatable. max value of int type 2^42. it's 20 billion.

do store on 20 billion rows in our datatable. if happens, think may have terrible performance. can image query such big info in 1 table.

so may int primary key id meet our requirement.

database int bigint