Reply to Re: Please help the performance issue.

Your name:

Reply:


Posted by jsfromynr on 12/15/05 15:32

Hi There,
Some minor suggestions

try not to use LIKE as in this case
AND Rel.PROJ_NAME LIKE 'R26.0'
Replace it with
AND Rel.PROJ_NAME = 'R26.0'


And Try to replace <> as below
AND Feat.CmtStatus <> 'Concept'
AND Feat.CmtStatus <> 'Identified'
AND Feat.CmtStatus Is Not Null

Let us say other CMTStatus which you want to check are
'Stage1','Stage2' etc
Then You can use
Feat.CmtStatus In ('Stage1','Stage2',.....)


These are the minor suggestions without looking at the database tables
and other aspects like table size , indexes it would be difficult to
arrive at some conclusion

With Warm regards
jatinder Singh

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация