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

How would you delete observations with duplicate keys?

6 Answers  


SAS System ?

5 Answers  


hi guys ...i have one query... data abc; input s w k g o t a m; cards; 1 2 3 4 5 6 7 8 2 3 4 5 6 7 8 9 ; run; i want the output to be the sorted order(only variables).observations should not be changed..

14 Answers  


How you can read the variables that you need?

0 Answers  


what do you mean by data staging area? : Sas-di

0 Answers  


what is washout period?

3 Answers   Cognizant,


Name the option to produce a frequency line items rather that a table.

2 Answers  


How would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable?

1 Answers   Quintiles,


what is in stream data in SAS?

1 Answers  


explain the key concept of sas? : Sas-administrator

0 Answers  


Is it possible to do sorting tranformation in charecter variable??if can tell me one eg..

1 Answers  


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

0 Answers  


Categories