> Params = field values, it is always tof_link_la_typ.lat_typ_id and > tof_link_la_typ.lat_ga_id i search, but always with diferent params.
OK > OS is Win7 x64 - its my development machine. > I plan to put database on win2008 R2 x64 server wit 20GB RAM. That is the right RAM size > I dont know what is depth of an index. The "depth" is one the value available from running gstat and getting/extracting index details. > Index is created as > CREATE INDEX TOF_LINK_LA_TYP_IDX5 ON TOF_LINK_LA_TYP (LAT_GA_ID, LAT_TYP_ID); I would see what happens if you delete that one and create an index with the order reversed. (You need to delete the current index to ensure that the optimizer choose the right PLAN) What about the suggestion to increase the database page size via restore?? That can make a difference. Sean
