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
[B]Question asked by visitor Pankaj[/b]
Printable View
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
[B]Question asked by visitor Pankaj[/b]
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 .