Thats right.

CREATE view t1t3

as

select t1.srno as T1SRNO,t3.srno as T3SRNO,t1.fname as T1FNAME, t3.fname as T3Fname, t1.lname as T1Lname,t3.lname as T3Lname

from t1 inner join t3 on t1.srno=t3.srno

CREATE view t1t3limit

as

select t1.srno as...

The size is varchar(100).

I am omitting some columns, ofcourse.

Heres the picture

I have two tables

T1 and T3, having similar structures.

fname varchar(100)

lname varchar(100)

srno int (identity)

In query I am omitting column T1LNAME and...

I dont have that info right now as I am not at my office, but the width (thickness) of a coulmn, how would it impact the query? Since they are...

Its a development environment, hence I can afford the restarts.

Query Analyzer is opened on the server PC so network is...

I executed these commands before I executed the queries.

DBCC FREEPROCCACHE

DBCC DROPCLEANBUFFERS

And if they werent enough, I even stopped and restarted my dev server.

The execution plans are as..

View - V1

OK I did some testing and here are my observations.

I created 2 tables each containing about 300000 records. I joined them in a view, didn’t use any where clause and...

Thanks for replying Lee.

I gave it some more thought and I think a stored procedure with a flag as an input parameter which would determine which query to execute (a...

Ditto.

Both A and B are correct answers. I chose A, do I still get the points?

In development environment usually, there is less load on the server (obviously), which is hosting the database hence the response time for the query is faster. But if the database...

Table variables are NOT created in memory. They are created in temp DB. As a rule of thumb use table variables if you are "NOT DEALING" with hugh...

Thanks for the info.

I could establish the connectivity using the IBM DB2 drivers

The problem was that the object owner for the schema table...

Can I specify the prefetch clause so that I can regulate (read increase) the number of rows of data that gets copied from the database to the client, as this...

The reason why I want asynchronous execution is because that way both the queries will get executed on the same connection simultaneously and at the same time hence it will...

Not physically , but mentally i could've

MARS

http://www.codeguru.com/Csharp/Csharp/cs_network/database/article.php/c8715__1/

I'm not much of a DOT net guy, but I did show this to...