https://communities.sas.com/t5/SAS-Enterprise-Guide/creating-index/m-p/766620#M39501 If you create the index on the Oracle side and use pass through SQL it will use the Oracle Index. <BR />If the data is in an Oracle DB create the indexes in Oracle. Working across DB types is always problematic though. Wed, 08 Sep 2021 15:26:23 GMT Reeza 2021-09-08T15:26:23Z https://communities.sas.com/t5/SAS-Enterprise-Guide/creating-index/m-p/766571#M39500 <P>Hello,</P> <P>&nbsp;</P> <P>One of my colleagues is asking if it is possible to create indexes at another location than the file location.&nbsp; I am not familliar with that at all.&nbsp; What I understand, he would like to create those indexes at the same place reserved for the Oracle table.</P> <P>&nbsp;</P> <P>Is it possible to provide me an example of to do it. Also, it will be nice to have a good document on that subject.</P> <P>Regards,</P> <P>&nbsp;</P> Wed, 08 Sep 2021 13:29:44 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/creating-index/m-p/766571#M39500 alepage 2021-09-08T13:29:44Z https://communities.sas.com/t5/SAS-Enterprise-Guide/creating-index/m-p/766620#M39501 If you create the index on the Oracle side and use pass through SQL it will use the Oracle Index. <BR />If the data is in an Oracle DB create the indexes in Oracle. Working across DB types is always problematic though. Wed, 08 Sep 2021 15:26:23 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/creating-index/m-p/766620#M39501 Reeza 2021-09-08T15:26:23Z