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

Difference b/n proc means and proc summary procedures?

3 Answers   Accenture,


what is the diff b/w verification validation in sas

3 Answers   SAS,


What is shift table? have you ever created shift that?

2 Answers   Accenture, Clinical Research, Quintiles,


What are the prime responsibilities of data integration administrator? : Sas-di

0 Answers  


We have a string like this "kannafromsalembut" ,from this i want to get only "fromsal" (but one condition with out using substring function)here we can not use scan because in the given string there is no delimeter? so give ans without out using substring ?

5 Answers  


What is the purpose of trailing @ and @@? How do you use them?

0 Answers  


What are the different operating system platforms in which we can use sas? : sas-grid-administration

0 Answers  


Enlist the functions performed by sas.

0 Answers  


how does sas handle missing values in assignment statements? : Sas programming

0 Answers  


how can you import .csv file in to sas? : Sas programming

0 Answers  


What is the difference between informat and format statement?

1 Answers  


how to generate means for every subject;

4 Answers   Mind Tree,


Categories