T-Sql view with addition where clause

[kaiso]

I have created a view which consists of 4 tables with a 'where clause' and an 'order by' statement.

If I then call this view and add an additional restriction -- such as 'where {datefield} = today', will the database generate the full record set with all possible dates before saying - hey I only need to find data dated today??

All help appreciated.

 

[philhege]

Kaiso,

I think it's more like "record 1 from my view, are you in?"

Y/N

Next....

So, yeah, it constructs the entire view first. That's what you're asking for.

Have you indexed the view or the columns that underlie the view? I suspect you're having performance problems, right?

Run it through QA with the Execution Plan turned on, and see what you can do with it.

HTH,
PH

 

[SQLBill]

Imagine a view as a temporary table that is created everytime the query is run.

So, by your query, first a temp table is created with all the requested information from the four permanent tables, then the last WHERE is run against the temp table.


-SQLBill

 

[philhege]

And with SQL2000 it's possible to index your views, so you should (if you use 2K) see a performance improvement.