>>>Hi, i have a view that it's taking almolst 5 seconds to show the results, the view if made of 7 tables, from them only one has a lot of records. And when in say a lot, for me it's only 45,000 records. I have indexes in all the fields that has a join, and also an index on DELETED(). Here's the SQL statment:
>>>
>>>

>>>SELECT Venta_diaria.codigo_vent, Venta_diaria.cantidad,;
>>>  Clientes.nombre, Programas.nombre, Marcas.nombre, Productos.nombre,;
>>>  Presentaciones.nombre, Tiendas.nombre, Venta_diaria.semana,;
>>>  Venta_diaria.mes, Venta_diaria.fecha, Venta_diaria.del, Venta_diaria.al,;
>>>  Venta_diaria.codigo_cli, Venta_diaria.codigo_prog,;
>>>  Venta_diaria.codigo_mar, Venta_diaria.codigo_pro,;
>>>  Venta_diaria.codigo_pre, Venta_diaria.codigo_tie, Venta_diaria.ano,;
>>>  Venta_diaria.modificado;
>>> FROM ;
>>>     sistema!marcas,;
>>>    sistema!productos,;
>>>    sistema!tiendas,;
>>>    sistema!presentaciones,;
>>>    sistema!clientes ;
>>>    INNER JOIN  "sistema!venta semanal" Venta_diaria ;
>>>    INNER JOIN sistema!programas ;
>>>   ON  Venta_diaria.codigo_prog = Programas.codigo ;
>>>   ON  Clientes.codigo = Venta_diaria.codigo_cli;
>>> WHERE ( (  Venta_diaria.codigo_mar = Marcas.codigo_mar;
>>>   AND  Venta_diaria.codigo_pro = Productos.codigo_pro );
>>>   AND  Venta_diaria.codigo_pre = Presentaciones.codigo_pre );
>>>   AND  Venta_diaria.codigo_tie = Tiendas.codigo_tie;
>>> ORDER BY Venta_diaria.codigo_vent, Venta_diaria.codigo_mar,;
>>>  Venta_diaria.codigo_pro
>>>

>>>
>>>From these table the big ones it's Venta_diaria wich has 45,000 records.
>>>Clientes has 3 Records.
>>>Programas has 8 Records.
>>>Marcas has 25 Records.
>>>Productos has 80 Records.
>>>Presentaciones has 250 Records
>>>Tiendas has 101 Records.
>>>
>>>Is it normal that to show this view it takes 5 seconds.
>>>
>>>I'm running windows 2000 Server with 320 MB RAM, IDE HD of 40 GB. and pentium III of 1 GHZ. Please tell me.
>>>
>>>Luis
>>
>>Would you try how ong this would take :
>>

>>Select Venta_diaria.codigo_vent, Venta_diaria.cantidad,;
>>  Clientes.nombre, Programas.nombre, Marcas.nombre, Productos.nombre,;
>>  Presentaciones.nombre, Tiendas.nombre, Venta_diaria.semana,;
>>  Venta_diaria.mes, Venta_diaria.fecha, Venta_diaria.del, Venta_diaria.al,;
>>  Venta_diaria.codigo_cli, Venta_diaria.codigo_prog,;
>>  Venta_diaria.codigo_mar, Venta_diaria.codigo_pro,;
>>  Venta_diaria.codigo_pre, Venta_diaria.codigo_tie, Venta_diaria.ano,;
>>  Venta_diaria.modificado;
>>  FROM sistema!venta semanal Venta_diaria ;
>>  inner Join sistema!Marcas ;
>>     on Venta_diaria.codigo_mar = Marcas.codigo_mar ;
>>  inner Join sistema!Productos ;
>>     on Venta_diaria.codigo_pro = Productos.codigo_pro ;
>>  inner Join sistema!Tiendas ;
>>     on Venta_diaria.codigo_tie = Tiendas.codigo_tie ;
>>  inner Join sistema!Presentaciones ;
>>     on Venta_diaria.codigo_pre = Presentaciones.codigo_pre ;
>>  inner Join sistema!Clientes ;
>>     on Clientes.codigo = Venta_diaria.codigo_cli ;
>>  inner Join sistema!Programas ;
>>     on Venta_diaria.codigo_prog = Programas.codigo ;
>>  ORDER By Venta_diaria.codigo_vent, ;
>>  Venta_diaria.codigo_mar,  Venta_diaria.codigo_pro
>>

Cetin
>
>Thanks, it's the same time.
Then try with 'force' clause and removing the deleted() tag(s).
Cetin