Thanks so much Anjela.
I tried testing the queries on the Information Map and again didnt see any visible difference in response time. I was hoping to look at the queries and try and figure out if the query was using the index. The source is indexed on 4 attributes and Year is one of them.Also since I created a simple index, the index itself will not have a name. Below are the queries
Query from Index Data Source
Proc SQL; Create Table %DATA% as
SELECT
SUM(table0.ACCTS) AS DIR_30 LABEL='Accts',
table0.CUSTOM_CHANNEL AS DIR_31 LABEL='Custom Channel' FORMAT=$20.,
table0.CLIENT_ID AS DIR_37 LABEL='Client Id' FORMAT=$20.,
table0.PRODUCT_TYPE AS DIR_38 LABEL='Product Type' FORMAT=$4.
FROM
ppaldata.ACQ_TEST_SAMPLE2_TEST1 table0
WHERE
table0.YEAR = '2009'
GROUP BY
2,
3,
4
;
quit;
Query from Non Index Data Source
Proc SQL; Create Table %DATA% as
SELECT
SUM(table0.ACCTS) AS DIR_2 LABEL='Accts',
table0.CUSTOM_CHANNEL AS DIR_3 LABEL='Custom Channel' FORMAT=$20.,
table0.CLIENT_ID AS DIR_5 LABEL='Client Id' FORMAT=$20.,
table0.PRODUCT_TYPE AS DIR_6 LABEL='Product Type' FORMAT=$4.
FROM
ppaldata.ACQ_TEST_SAMPLE2 table0
WHERE
table0.YEAR = '2009'
GROUP BY
2,
3,
4
;
quit;
Is there a way I can be sure that the query used the index?Meanwhile I will also go through the paper.
Again, thanks for the all the help.
Tej
