Thanks for the answer si_the_geek

the fact that it stored inside the db not change much for me cause all my queries is already in the form of SPs, but it good to know that the query been optimize do you know by any chance in what way it been optimize ? is the server changing the query syntax? (i guess not) adding indexes maybe? adding statistics ?


one more question: now that i understand the benefits of VIEWS (and it really has) should i start thinking different and use it a lot? is it common to use VIEWS very frequently ?

Thanks again.