Database Design
-
Hi ,
Can any one provide me material for database design?
I am a .net developer and also have worked in supporting SQL server 2000 .
Thanx in advance .
Can anyone provide me a method to convert OR condition in where clause to AND condition as it improves query performance .?J
-
Hi,
These are links which will help you on database dsign.
http://www.casestudio.com/enu/database_design_freeware.aspx
http://www.datanamic.com/dezign/index.html
www.databaseanswers.com/modelling_tools.htm
Can anyone provide me a method to convert OR condition in where clause to AND condition as it improves query performance .?
You have to rewrite the query and remove the OR operator.
It will be better if y ou have index column for AND condition. Query will be fast.
Check the BOL for more info on Query tunning.
Query Tuning
Query Tuning Recommendations
Minaz Amin
"More Green More Oxygen !! Plant a tree today"
-
AND and OR are different and provide different functionality, properly optimised either can be fast.
Always worries me when dot net devs need help with database design and query writing, I'd always suggest training courses and BOL
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/ -
thank you
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply