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?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

in the flow of data step processing, what is the first action in a typical data step? : Sas programming

1022


what is proc Index? and what is proc document?

2643


how many types prompting framework can be broken down to? : Sas-bi

1039


What Proc glm does?

1036


How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?

1628


Tell e how how dealt with..

2215


What is the function of output statement in a SAS Program?

1019


I need level 2 to 5 sas using companies in india

2336


Give e an example of..

2284


Explain the purpose of retain statement.

1014


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

985


explain about various caches available in data integrator? : Sas-di

1000


What is the difference between one to one merge and match merge? Give an example.

1007


Name few SAS functions?

1046


What do the PUT and INPUT functions do?

1273