03-06-2017 12:06 PM - edited 07-15-2021 03:10 PM
How do I create an index on a field in my database table?
An index for a field can be created using the Post Create SQL Statement option (option #10) found in the Configuration window of the Input tool.
The following example applies to MS SQL Server only and creates an index for the column "City" in the table co_store_file_north.
Important: You must use the SQL code that is appropriate for your database. For instance, the example shown below will not work for Oracle.
Steps
CREATE INDEX index_city ON co_store_file_north (City)
Keep in mind that both the Pre and Post Create SQL Statement options are only available for specific connection types. Per the Help section, only the following connection types are supported:.mdb, .mdb*, .oci, .accdb, ODBC, OLEDB.
Thanks for reading!
Hi,
Is there any way to do Indexing using In-Database tools? My Data Source is Amazon Redshift and the nature of data is Sensor Data, count comes in Millions.
Please advice.
Regards,
Sreekanth