Hi, I am curious if anyone is applying indexes to the SAS CDM tables. For example, putting on a unique index on the PATID in the DEMOGRAPHIC table.
One way it can be done is with "proc sql" steps using "create index" commands. I am guessing that this could dramatically impact the time needed for running the Data Characterization Query and such. If anyone is doing that and could share the actual indexes that they are applying, it would be of help. Thanks! Jay Pedersen, M.A. Department of Pathology/Microbiology University of Nebraska Medical Center 985900 Nebraska Medical Center Omaha NE 68198-5900 402-559-9487<tel:402-559-9593> (office) 402-739-3496<tel:402-350-7851> (mobile) The information in this e-mail may be privileged and confidential, intended only for the use of the addressee(s) above. Any unauthorized use or disclosure of this information is prohibited. If you have received this e-mail by mistake, please delete it and immediately contact the sender.
_______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
