I would create two separate indices on fields B and C
Olaf
On 6/16/09 4:25 AM, "Yariv Omer" wrote:
> Hi
>
> I have the following problem
>
> I have a table with 3 fields ('Field_A', 'Field_B', 'Field_C')
> My query is:
>
> Select Field_A from table where Field_b=10 order by Field_c ASC;
>
Hi
I have the following problem
I have a table with 3 fields ('Field_A', 'Field_B', 'Field_C')
My query is:
Select Field_A from table where Field_b=10 order by Field_c ASC;
I have performance issues even when i have tried to define index for
this table
How should i define the corerct index (b
