Table design where every column can be in WHERE clause

[Michael Zatkovetsky]

Hi! I hope I am posting in the correct forum.

I have a table with very heavy insert activity.
I also need to query from this table for reports etc.
The requirement is that users must be able to query on every single column of the table.
My dilemma: if I index the table, then the inserts are going to be slow but I can query.
If I do not index the table, then the inserts are fast but queries are slow and can slow down the inserts.

What is the proper way to model/design/architect for situations like this? I know there is no single answer and the solution can be very complex. I was thinking along the lines of moving data somewhere else asynchronously but the move itself but slow things down. Besides, are there any built in facilities for such data move?

You input is highly appreciated in advance

Mike