3 ms·
If you have specific columns that you frequently want to ignore (which, I think, is the common case of this), you could define a view that selects all the colum
by bobbyi 5y ago
If you have specific columns that you frequently want to ignore (which, I think, is the common case of this), you could define a view that selects all the columns except those and do your queries against that view.
- Eremotherium 5y agoOr create a function that returns a view of a table minus named columns in situ if that's really a common case for you. Just as an idea.
- fendy3002 5y agoIirc in some older db it won't be able to use indexes this way. Don't know if still applied nowadays.