I'm prototyping a design. In the design, I am considering creating a thin xref table (two integer fields) that would contain approximately 25 million records. Is this a crazy idea or would I still expect decent performance? By decent performance, I expect to query against this in a second or two. I plan to index the first column.
I'm on Oracle. I know this is a bit subjective as far as how the DB is tuned out, but let's assume I'm not doing anything too elaborate on the Oracle configuration side. Just a ballpark - what kind of damage am I looking at?
I welcome ideas for breaking down an xref table if my approach seems ridiculous.