Hi,
I configured the transactional replication using push method. I use the option generate snapshot. Until the Snapshot complete, I didn't any tables in the subscriber db.
After that also I can see in some tables it has indexes and some tables it doesn't but it has data in that table .
How does the bulk copy works from snapshot?
i.e. is it first create the table with columns then insert data later it will create the indexes
Please let me know. How the sequence works in the subscriber
Is it creates based on the object ids asc or any another way