|
"It
was our first week using iSight and I ran a report showing all
queries that returned more than 5,000 rows, thinking it was a
good place to start. At the top of the list were two queries
that each returned 13 million rows and ran for more than sixteen
hours! When I drilled down to the detail
report, I discovered the
problem—the queries were identical Cartesian joins issued by
the same user, the first issued around 9:00 am and the second
after lunch."
A
"Cartesian join" occurs when two tables are joined
without specified join criteria. As a result, every row in the
first table is combined with every row in the second table. This
produces an enormous result set that can run for hours or even
days and is of no use.
|