When i want to delete rows from a table which has million records then which is the best to do it .
It has indexes ,clusters and so on and it's parent table too .

I want to know what will be the real scenario ,if i use and which is faster and advantages over other