Re: are hints still necessary in 9i?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 9 Oct 2003 08:34:03 +0100
Message-ID: <bm3305$i9f$2$8300dec7@news.demon.co.uk>

The easiest option is to store dates
in numeric or string format - e.g.

20031231
or

'20031231'
for 21st Dec 2003.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html
____Iceland__November (tbc)
____Belgium__November (EOUG event)
____UK_______December (UKOUG conference)


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____USA__October
____UK___November


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


"Ryan" <rgaffuri_at_cox.net> wrote in message
news:3q%gb.54647$0Z5.93_at_lakeread03...


> you mentioned a design that will cripple the CBO. The one I know

that is


> common amongst cross platform applications is using layered complex

views


> going up 5-7 layers or more. Ive tested this and find the RBO to be

faster.


> Most of the vendors tell you to use the RBO against that design. I

think


> they choose it so they dont have to change their application layer

when they


> move from one DB to the next. They just change the view syntax.

>

> what other designs cripple the CBO?

Received on Thu Oct 09 2003 - 02:34:03 CDT