how can you improve the performance of a query, If it is
excuting very slowly?

Answer Posted / himanshu

by creating the Cubes, We can improve the performance of
the query.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the data types in sas?

621


What does the RUN statement do?

861


how does sas handle missing values in procs? : Sas programming

643


How do you delete duplicate observations in sas?

586


explain the difference between proc means and proc summary?

680






If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?

712


describe about metadata object? : Sas-di

634


Which are the statements whose placement in the data step is critical?

768


Can you explain the process of calendar?

650


What is the different between functions and PROCs that calculate the same simple descriptive statistics?

1241


what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake

1924


is data integration and etl programming is same? : Sas-di

586


Name validation tools used in SAS

704


What are the features of SAS?

592


How sas treats the dsd delimiters?

730