Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

Answers were Sorted based on User's Feedback



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

Answer / dvsr

If you are execution query on large SAS data sets before
executing the query COMPRESS the data sets by using
sas “compress” option and create the indexes on the most
frequently using variables in the data set

Feel free To add more ….:)

Is This Answer Correct ?    3 Yes 1 No

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

Answer / himanshu

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

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SAS Interview Questions

We want to merge file A and B. File A has variable age, file B provide birthdate. How to merge the data according to age in file B

3 Answers  


who is the best SAS clinical Trainer in Hyderabad?

3 Answers  


what is enterprise guide? What is the use of it? : Sas programming

0 Answers  


In the flow of DATA step processing, what is the first action in a typical DATA Step?

9 Answers  


What is the difference between %put and symbolgen? : sas-macro

0 Answers  


Hi, I have one dataset like id date ex: id date 1 13 1 13Oct2011 2 14 2 14Oct2011 3 15 3 15Oct2011 --->this is the current date here i want date format like 13Oct2011,14Oct2011 how we can modify the numeric to date format plz answer.

4 Answers  


how we can call macros with in data step?

17 Answers   Allianz, ManPower,


sas implimented companies in hyderabad

11 Answers   CTS, HSBC,


How to import the Zip files into SAS? If it is possible in SAS? If it is posible write the code...

7 Answers  


Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?

0 Answers  


What is the difference between match merge and one to one merge?

0 Answers  


what are the new features included in the new version of SAS i.e., SAS9.1.3?

5 Answers   College School Exams Tests, Wockhardt,


Categories