Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Time out Expired Expand / Collapse
Author
Message
Posted Friday, June 7, 2013 9:45 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, August 21, 2016 1:11 AM
Points: 87, Visits: 606
i am using CTE in following ways


with CTE1
(
select * from xx
),
CTE2
(
select * from test inner join CTE1 CT on test.id=CT.id
) ,

CTE3
(
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.
Post #1461141
Posted Friday, June 7, 2013 9:52 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:04 AM
Points: 14,458, Visits: 37,981
vs.satheesh (6/7/2013)
i am using CTE in following ways


with CTE1
(
select * from xx
),
CTE2
(
select * from xx a inner join CTE1 CT on xx.id=CT.id
) ,

CTE3
(
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?



Lowell

--
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!
Post #1461144
Posted Friday, June 7, 2013 1:42 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, August 12, 2016 4:42 PM
Points: 333, Visits: 1,486
vs.satheesh (6/7/2013)
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.
Have you looked at execution plans already?



Alex Suprun
Post #1461210
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse