Re: OUTLINES

On Mon, 17 Jul 2006 05:54:34 +0100, Niall Litchfield wrote:

My reading of the reply was not that, but that one had to work out what
cursor_sharing would do to the query (or just capture the rewritten
query) and duplicate that work.

i.e instead of doing

create stored outline for ' select * from t1 where n1=1'

do

create stored outline for 'select * from t1 where n1 = ":SYS_B0"'

Niall, outlines are usually used during upgrades, to ensure that the
application system will perform as it used to, when the software is
upgraded to the new version. The kind of work you're describing means
that you're SOL when it comes to an application system with possibly
thousands of SQL statements. It's much easier to turn off cursor sharing,
especially because it has an extremely bad rap, because of the bugs in
version 8i and early versions of 9i so not many people are using it. My
biggest problem with the outlines is that they're usually situated in
the system tablespace, which can cause trouble.

--
http://www.mgogala.com

.

Relevant Pages

  • Re: duplicates query help & strategy for update queries with SetWarnings = False
    ... I'm calling a function that will set the occurence number. ... If there's a duplicate, ... I used the query wizard to create a "find duplicates" query, now I need to adjust the results of that query to add an occurence counter/number, and I'd be set. ... Once the user has handled all the problems, you enable the final command button at the bottom of the form, which executes an append query to add the data to the real table. ...
    (comp.databases.ms-access)
  • Re: Identifying Duplicate Records
    ... Indeed, the duplicate records ... Discovering the Find Duplicate query, ... or bring up the dupe records to look at them. ... have a find duplicate records wizard. ...
    (microsoft.public.access.formscoding)
  • Re: Identifying Duplicate Records
    ... the duplicate records problem represented one of the few occasions ... the Find Duplicate query, however, has allowed me to plug another gap in my ... or bring up the dupe records to look at them. ...
    (microsoft.public.access.formscoding)
  • Re: duplicates query help & strategy for update queries with SetWarnings = False
    ... After playing around with duplicates, and a funtion to generate an occurence number, it looked like you would need a handful of queries per table!! ... Once the user has handled all the problems, you enable the final command button at the bottom of the form, which executes an append query to add the data to the real table. ... On a "Find Duplicates Query", does anyone have a good solution for renaming the duplicate records? ...
    (comp.databases.ms-access)
  • Re: Please help!
    ... From the 2nd row down to the last is the same duplicate ... Allen Browne - Microsoft MVP. ... In a query, depress the Total button on the Toolbar. ... Access adds a Total row to the grid. ...
    (microsoft.public.access.forms)