Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Insert date and time to a table

Re: Insert date and time to a table

From: Chris Hamilton <ToneCzar_at_erols.com>
Date: Thu, 17 Jun 1999 12:42:57 GMT
Message-ID: <376aed2d.2210388@news.erols.com>


On 16 Jun 1999 19:18:59 PDT, y2000_at_pacbell.net (Y2K) wrote:

>Would there be any performance issues if I do this:
>
>select * from employee where ename like 'a%' or ename like 'A%'
>
>I mean it would still use indexes, right?

That would work.

Chris



Christopher Hamilton
Oracle DBA -- Wall Street Sports
chris_at_wallstreetsports.com
http://www.wallstreetsports.com/ Received on Thu Jun 17 1999 - 07:42:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US