How can I imporove my query performance

[Geek_Guest]

How can I imporove my query performance does anybody know how to write query plz tell me ways (like----- instead of using one keyword use other keyword so your query performance will be better) like that

Question asked by visitor Pankaj

[debasisdas]

1.Try to create index on the columns which are used more frequently in the where clause of your query.

2.Try to pass hints in the query .