Search

OakieTags

more tags

Who's online

There are currently 0 users and 30 guests online.

Recent comments

Affiliations

Home

CONNECT BY oddity

Submitted by Timur Akhmadeev on Wed, 2010-04-07 20:09

This week I’ve seen an issue with a CONNECT BY query: for some reason Oracle 10.2.0.4 decided to build a weird plan (the query is weird too, but that’s not my point here ). An explanation of why that happened looks interesting, so here it is. Set up: drop table t2 cascade constraints purge; drop [...]