SQL Views Degrading Performance

[RileyCat]

Is it possible for a SQL View to degrade performance vs. querying the tables directly?

I have two different views. One is just a single table query. The table is not indexed (long story). The other view joins with one other table which also is not indexed.

So is it possible for the Views as described above to take longer to perform or degrade performance vs. querying the tables directly?

Stay Cool Ya'll!

-- Kristin

 

[TheBugSlayer]

Did you get a better performance when querying the tables directly? It seems to me your problem is in the lack of indexes.

MCP SQL Server 2000, MCTS SQL Server 2005, MCTS SQL Server 2008 (DBD, DBA)