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...

what is the need of INDEX in datasets?

Answer Posted / dvsr

Without index if we executed the query it will go to the
full table scan. If any data set or table has the index
first query checks that particular If condition or where
condition in that column then it will go to the remaining
columns.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Given an unsorted data set, how to read the last observation to a new data set?

1407


Explain data step in SAS

1159


Mention what are the data types does SAS contain?

1192


how do you want missing values handled? : Sas programming

1012


What are the limitations for memory allocation for SAS variables

1547


How will you use the WHO Drug Dictionary for Reporting Clinical Trials?

2394


Describe the function and untility of the most difficult SAS macro that you have written.

2274


Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?

2306


How to limit decimal places for the variable using proc means?

1120


what is the difference between floor and ceil functions in sas? : Sas-administrator

1314


What is the basic syntax of a sas program?

1262


Why double trailing @@ is used in input statement?

1265


What is the order of application for output data set options, input data set options and SAS statements?

1618


how to generate the test data in sas without input data? : Sas-administrator

1176


what is the difference between infile and input? : Sas-administrator

1193