Forum Discussion
mandar
3 years agoFrequent Visitor
Only import used columns
Hi, In few of our reports we have used select * to pull all the columns from the views and as you can imagine its not gone too well with the client. Is there a way I can easily identify the c...
- 3 years ago
There is no exact process behind this. The moment you remove a column a business user will call you and ask where that column went.
Your tables should be long and narrow. If they are then you should be able to load all (or most) columns to be prepared for changes in business requirements.
lbendlin
Super User
3 years agoThere is no exact process behind this. The moment you remove a column a business user will call you and ask where that column went.
Your tables should be long and narrow. If they are then you should be able to load all (or most) columns to be prepared for changes in business requirements.