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

what does the run statement do? : Sas programming

993


what is star schema? : Sas-di

1075


what are the categories that sas informats are used to the place the data? : Sas-administrator

992


What is the basic syntax of a sas program?

1146


To what type of programms have you used scratch macros?

2530


if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming

1005


Mention what is the difference between nodupkey and nodup options?

954


What are the data types does SAS contain?

1053


Name and describe few sas character functions that are used for data cleaning in brief.

1058


What was the last computer book you purchased? Why?

2316


What are the advantages of using sas?

1096


explain the difference between proc means and proc summary?

1074


AE datasets names? how many types?

2448


what is the difference between nodup and nodupkey options? : Sas programming

1114


What is the role of unrestrictive users? : sas-grid-administration

956