I'm deleting from parent->Child->GrandChild
And i'm looking at Recent expensive Queries in activity monitor to get the averageduration.
My Table Structure is like
Student Table in which i have student id as the primary key
StudentInfo table in which i use the StudentId as the primary key and foreignkey
so if i delete a student record i will be deleting the records of that student in studentinfo table.
Sorry if this is not clear