We just get the index hint copied around the place - fortunately generally
the table is either not used in the new query or else it is aliased
differently :( What worries me is that these are accountants using an
end-user tool, so this kind of thing is to be expected. When developers
start doing it :(
--
Niall Litchfield
Oracle DBA
Audit Commission UK
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Billy Verreynne" <vslabs_at_onwe.co.za> wrote in message
news:bcmcl4$29l$1_at_ctb-nnrp2.saix.net...
> Nuno Souto wrote:
>
> > Does this happen to you folks as well?
> >
> > Finding your own code, complete with the little
> > "inconsistencies" that make it your own, copied
> > and pasted one year later into someone else's
> > "Initial coding"?
> >
> > Pisses me off no end...
>
> Yeah.. it's like having an admin/operator seeing you use a /*+ FULL(x)
> PARALLEL(x,10) */ for a QFH (Query From Hell) and then proceed to use this
> piece of code in every friggen SQL they use as it is now The Magic Wand
> That Makes Oracle Go Fast.
>
> See Oracle. See Oracle Run. Run Oracle Run.
>
> I better get some coffee in me pretty quickly before I grab my lead
pipe*...
>
> --
> Billy
> * there is no problem that can not be solved with the dedicated, focussed
> and extreme application of mindless violence.. using lead pipes of course.
Received on Tue Jun 17 2003 - 03:14:46 CDT
