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 |
|
DanAgnew
Starting Member
2 Posts |
 Posted - 2009-09-10 : 13:29:10
|
| I am using SQL 2000 for a project and having some major performance issues involving ntext fields and joins. I have a table (products) that contains several ntext fields. I need to join this table to higher level tables (category and subcategory tables). When I create my store procedure and run it, the execution plan shows that the select is using Bookmark Lookups to get the product data. This is causing a huge performance issue. The product table has over 60,000 records and to return a subset of 1,021 records is taking four to five seconds when I add my joins. The execution plan says that 80% of the Query cost is the Bookmark Lookup on my product table.I know that text/ntext is bad, but I don't have a choice because the data in the text fields adds up to over 12,000 characters - way bigger than the SQL record size limit.My questions are:1 - Using SQL 2000, is there a way to avoid bookmarks while using ntext2 - Is this problem something that can be solved by switching to SQL 2008 and using the Included Columns index feature?I prefer to not have to do a SQL upgrade to fix this if I can help it.ThanksDan Agnew |
|
|
|
|
|
Performance issues with joins and ntext fields