Virat is a
Curious Researcher
Recap 2022
Publications:
2questions
1discussion
Top Post:
478
people reached
User bio
404 bio not found
Member since Dec 15, 2018
Replies:

Query Plan:

Relative cost = 21418093

Read master map SQLUser.RecordsMASTER, looping on id and ~{330}*10(qw).

For each row:

 Read master map SQLUser.Orders.Orders, using the given idkey value.
 Read master map SQLUser.OrderedBooksMASTER, using the given idkey value.
 Read master map SQLUser.BooksMASTER, using the given idkey value.
 Read master map SQLUser.OrderedRecordsMASTER, using the given idkey value.
 Output the row.

Index is on property qw and not on er

indices is qw (in both class) but not on er.

Not sure of %parallel mode. How does this work? is this something similar to running the job in background.

Query Plan:

Relative cost = 21418093

Read master map SQLUser.RecordsMASTER, looping on id and ~{330}*10(qw).

For each row:

 Read master map SQLUser.Orders.Orders, using the given idkey value.
 Read master map SQLUser.OrderedBooksMASTER, using the given idkey value.
 Read master map SQLUser.BooksMASTER, using the given idkey value.
 Read master map SQLUser.OrderedRecordsMASTER, using the given idkey value.
 Output the row.

Index is on property qw and not on er

Followers:
Virat has no followers yet.
Following:
Virat has not followed anybody yet.
Global Masters badges:
Virat has no Global Masters badges yet.