SQL & PL/SQL

Hi all !!!

This is my situation, i have a table, with this "static" columns id, first_name, last_name and i want to add columns to this table dynamically, and i need to query this table using this new columns, the data in this table is huge, and without indexes the full scan of this table using the "dynamic" columns is really slow, i down want to create indexes for each column i create, is a bad practice and if for some reason the number of this dynamic columns is 100 i do not want to have 100 indexes for this table.

1- There is a way to make the queries faster on this table using the "dynamic" columns?
2- If i use a view i need to alter the view to add the new column each time i create a new column?

Hope someone can help me with this...

Best regards and blesses!