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
what is data access? : Sas-di
How do you delete duplicate observations in sas?
What is the differnce between SDTM 3.1.2 to 3.1.1 version
What is substr function?
I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.
what are the benefits of data integration? : Sas-di
Can you suggest us materials for sdtm mapping?
What is the difference between proportion and average?
Are you involved in writing the inferential analysis plan? Tables specfications?
what are the component of range? : Sas-bi
Explain by-group processing?
Describe 5 ways to do a “table lookup” in SAS?
What do you know about symput and symget?
Explain the purpose of retain statement.
Difference between nodup and nodupkey options?
