hi Is it necessary to reorg and reindex the indexes in the Distribution DBs? I am creating a stored procedure using some of the tables in this DB and is running very slow.
Yes you should be reorg-ing indexes periodically. Replication agents INSERT, UPDATE and DELETE data as required just like any other database and, hence, the table issues with fragmentation will arise.