Compiling a Complex Query

complex views that have a lot of joins, and sequels over compiles plans for them quickly. The more joins you get, the more ways there are that things can go wrong with query. When i do see multiple seconds of time used in compilation, i try to figure out what the cause is. One cause might just be that the sequel server may have made the query wait on a cpu res figuring out how to do the plan right - very s pu intensive.