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.
| Author |
Topic |
|
rds207
Posting Yak Master
198 Posts |
 Posted - 2009-11-11 : 18:57:52
|
| Hi I have created a view based on two columns the join condition is some thing like this :CHARINDEX(B.PHONE_BUILD + '_', A.JOB_NAME) > 0 ORCHARINDEX(B.PHONE_BUILD + 'Blueprint', A.JOB_NAME) > 0 ORB.PHONE_BUILD = A.JOB_NAMEThis involves in lot of parsing of the huge data, The problem is the performance of teh view is very low, the records are being retrived very slow , i heard from someone that creating an index would make the performance better, could anyone please let me knwo how to create an index on view... |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
rds207
Posting Yak Master
198 Posts |
Posted - 2009-11-11 : 19:15:55
|
| Sample Data:Phone_Build Job_nameM76XXTFGCHNAAD1202 M76XXTFGCHNAAD1202_rel_31JUL2009_094725pmM76XXCSDCBODAD35808P M76XXCSDCBODAD35808PBlueprint_30JUL2009The whole objective of the view is to link phone build and jobname,the jobname is uniue , so may be i can create index on job_name.. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
rds207
Posting Yak Master
198 Posts |
Posted - 2009-11-12 : 12:49:12
|
| thank you for the reply ...Is this the syntax for creating index,? |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
|
|
Creating Index on View