Optimizing Query

[xpcer]

hi, friends, i have an problem, like this,
i have tables, when i want to use "select" statement that include "join" sintaxt, my query will execute about 1 hour, so long.

can u tell me how to optimizing my query, may be using index, or another?

[aps786]

hi, friends, i have an problem, like this,
i have tables, when i want to use "select" statement that include "join" sintaxt, my query will execute about 1 hour, so long.

can u tell me how to optimizing my query, may be using index, or another?

give your table structure and query that u are firing.