i am using CTE in following ways
select * from xx
select * from xx a inner join CTE1 CT on xx.id=CT.id
select * from yyyy
select * from CTE1
inner join CTE2 on CTE1.od=CTE2.id
inner join CTE3 on CTE3.id=CTE1.id
My question is
I am give select * means its retrieving with in two seconds.But I am specify column name means Its taking 5 min .I am really surprised. Please give me a solution.
well, it looks to me like your pseudo code doesn't show us enough;
CTE2 would fail because the column names are not unique, since you are selecting from the same table [xx] twice
can you show us either the real sql you are using, or a find-and-replace obfuscation, instead?
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!