Speed on 4M query

If I have optimal server configuration and decent system hardware specs(dual quad core, 8G ram, 150mb/s read times) How long can I expect to wait to query a column with 4 millions rows(20 chars per row).

Do you mean without using indexes or?