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

explain what is factor analysis? : Sas-administrator

0 Answers  


what is treatment emergent events and treatment emregent adverse event

0 Answers  


Hi, I need to create a SAS Map of USA using SAS Graphs(Proc Gmap).The data i have dosent contain any co-ordinates of USA cities or counties or states, and the zip codes are diffrent in the data i have from the zip code in the Maps.US dataset in the Maps Library for SAS MAPS. the data i have is a sales report. i have to generate the maps according to the states,cities aligned in the sales data, HELP Appriciated

1 Answers  


what are validation tools that are used in sas? : Sas-administrator

0 Answers  


Enlist the syntax rules followed in sas statements.

0 Answers  


There are 200 observations in a dataset, i want to pull out the observation no's 100, 150,180,190 by using Proc SQL? How you can get it?

5 Answers  


what are the different ways of merging two datasets.name atleast 4.

2 Answers  


how to perform paired t-test using Base/SAS & SAS/Stat?

2 Answers  


Tell e how how dealt with..

0 Answers   Wipro,


What was the last computer book you purchased? Why?

0 Answers   Oracle,


What is the purpose of _error_?

1 Answers   Quintiles,


Which are the statements whose placement in the data step is critical?

0 Answers  


Categories