Have this a SQL stored procedure, amount of data in 200 million, the manual query about 50 minutes time, in the process of put in storage, after 3 days no more than, this procedure has two copies, a day is about two hours to complete, no more than 3 day of what happened? Is time parameter, which bosses look (no indexes in the table, can't add, master the partition table)

CodePudding user response:

Need to see if there are any locks, or wait for events, temporary table space, etc