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 thi
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
UP> Hi Taka,
>> I have an object model that looks like this:
>>
>> OBJECT 1
>> - item 1
>> - item 2
>> - item 3
>>
>> OBJECT 2
>> - item 1
>> - item 2
>>
>> OBJECT 3
>> - etc...
>>
>> These are stored in tables like this:
>>
>> CREATE TABLE object
>> (
>
3 matches
Mail list logo