I looking for solutions about index in data warehouse database.

what is best practice?
if index(es) not created load is fast, but query is slow.

how this solving?
if we want index(es) and velocity of insert records in table.

because if index(es) created, load in table is slow or maybe I'am wrong beacuse I don't no which velocity of insert records is on good server.

If you can load at night but query during the day then during the load process: drop the index, load the data, then recreate the index.

this is OK.

but, what if I have many records in table?

maybe few bilion record in table and load new data, drop index lasts few hours and create lasts few hours?

what then?

Then you buy a bigger machine. A lot bigger. And faster.

thanks