optimizing a query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

optimizing a query

Author

Topic

msrs

32 Posts

Posted - 2007-11-27 : 05:30:04

hi all

Ifor
Aged Yak Warrior

700 Posts

Posted - 2007-11-27 : 06:29:13

1. Check your indexes.
2. Look at putting the logic in the functions into the main query.

PeterNeo
Constraint Violating Yak Guru

357 Posts

Posted - 2007-11-27 : 06:31:10

Hi Msrs,

move the conditions to inside of derived table definition

(
(
oatable030.branch_id = '7f4932a5-4709-40c8-a87f-c2d978a2fd2f'
OR oatable030.branch_id = '799b860e-a832-4a68-8e94-fada44bbb7b9'
)
AND oatable030.acc_type_id ! = 'c'
AND oatable030.acc_type_id ! = 'v'
)

and

(
(
OATABLE014.branch_id = '7f4932a5-4709-40c8-a87f-c2d978a2fd2f'
OR OATABLE014.branch_id = '799b860e-a832-4a68-8e94-fada44bbb7b9'
)
AND OATABLE014.acc_type_id ! = 'c'
AND OATABLE014.acc_type_id ! = 'v'
)

ditch
Master Smack Fu Yak Hacker

1466 Posts

Posted - 2008-01-09 : 03:54:33

Is this another case of the OP deleting his question after it has been answered, making it difficult for others to learn from?

Duane.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-01-09 : 04:42:59