"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.

 

 

 

 

 

Preventing Problem Queries

Kevin Larsen

Database Administrator

 

>>

<<

home