I have a request against a teradata view that retrieves 250 columns for one row.

It takes 30 seconds to come back.

When this row is retrieved from teradata directly it takes 3 seconds.

my code looks like

TABLE FILE XXX
PRINT (LIST OF 250 FIELDS)
IF SSN EQ '&SSN'
END

THE SQL MESSAGE COMES BACK AGGREGATION NOT DONE BECAUSE IT DOESNT APPLY TO THE VERB.

Is there any way to speed this up?

Is there any SET parameters that can be set?

Thank you very Much

Code the SQL in WebFOCUS and see how long that takes. SQL Pass-Thru.

Scott