DEV Community

[Comment from a deleted post]
Collapse
 
aarone4 profile image
Aaron Reese

Depends.. but I agree it smacks of poor design in most cases. I once had a vendor write a custom view which (due to their security model) returned an error when I tried to use it because MSSQL is limited to 260 joins in a single query. O re-wrote it in about 20 joins and unsurprisingly it took 1/8 the time to execute