Component Integration Services includes changes to the create index command.
When the server receives the create index command, it passes the command to an appropriate access method, if the object on which the command is to operate has been associated with a remote or external storage location.
The command is reconstructed using a syntax appropriate for the class and is passed to the remote server for execution.
create index is passed to remote servers as a language request.
See also create index in the Reference Manual: Procedures
Component Integration Services forwards everything except the on segment_name clause to the remote server.
Component Integration Services forwards everything except the on segment_name clause to the remote server.
Component Integration Services forwards everything except the on segment_name clause to the remote server.
When the language capability is set to “Transact-SQL”, Component Integration Services forwards all syntax except the max_rows_per_page and on segment_name clauses to the remote server.