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 we can create optional or required parameters in SAS macro...

5 Answers   TCS,


What do the mod and int function do? : Sas programming

0 Answers  


Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??

0 Answers   Oracle,


Can you execute a macro within a macro? Describe. : sas-macro

0 Answers  


What is the order of evaluation of the comparison && logical && relational operators:?

2 Answers   CitiGroup,


how do u validate sas program

3 Answers   Accenture,


Explain the special input delimiters used in sas programming.

0 Answers  


How many data types are there in SAS?

0 Answers  


I have a dataset concat having variable a b & c. How to rename a b to e & f?

0 Answers  


explain the main difference between the nodup and nodupkey options? : Sas-administrator

0 Answers  


What are the features of base sas system?

0 Answers  


What is the pound sign used for in the data_null_ ?

1 Answers  


Categories