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 is hierarchy flattening? : Sas-di

614


How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

634


Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya

1343


Briefly explain input and put function?

621


what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi

548






it will become easy if uuu provide website linkssss and list of consultanciessssss

1526


explain the key concept of sas? : Sas-administrator

554


Differentiate between ceil and floor functions.

656


How to create an external dataset with sas code?

583


what is sas database server? : Sas-di

611


Explain why double trailing @@ is used in input statement?

569


What is slibref?

744


What are the ways to do a “table lookup” in sas?

589


How do you specify the number of iterations and specific condition within a single do loop?

616


Tell e how how dealt with..

1766