I have a table that will have millions of entries, and a column that has BIGINT(20)
values that are unique to each row. They are not the primary key, but during certain operations, there are thousands of SELECT
s using this column in the WHERE
clause.
Q: Would adding an index to this column help when the amount of entries grows to the millions? I know it would for a text value, but I'm unfamiliar with what an index would do for INT
or BIGINT
.
A sample SELECT
that would happen thousands of times is similar to this:
`SELECT * FROM table1 WHERE my_big_number=19287319283784
See Question&Answers more detail:os