FYI:
If you have a very small number of rows in the table and index will
make it slower,
rather than faster.
On 11/21/05, Wilfried Mestdagh <[EMAIL PROTECTED]> wrote:
> Hi Bert,
>
> >>'select distinct Name ' +
> >> 'from Rx ' +
> >> 'where RxDT >= ' + DT + ' ' +
> >> 'order by Name'
>
> One
On Wed, 27 Oct 2004, Taka Muraoka wrote:
>UP> Hi Taka,
>
>>>
>>> These are stored in tables like this:
>>>
>>> CREATE TABLE object
>>> (
>>> object_id INTEGER PRIMARY KEY
>>> ) ;
>>>
>>> CREATE TABLE item
>>> (
>>> object_id INTEGER ,
>>> seq_no INTEGER
2 matches
Mail list logo