Advertisement

08.29.2008 at 02:31PM PDT, ID: 23690202
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!
8.5

Need help with abstract query plan syntax

Asked by BenSlade in Sybase Database

Tags: , ,

I'm new to Sybase ASE abstract query plans.  For the code snippet below, don't worry too much about what the query does, but I'm just trying to get a valid syntax for the abstract query plan at the end.  

It just gives me the error:   syntax error; line 1, occurring near 'nl_join'

It looks just like what's in the manuals.  So I'm stumped.

Background:

There is a clustered index named cidx on the #tmp table with all the columns in the order by.  The query (without the query plan qualifier) normally returns rows in the order of the clustered index/order-by *without* doing sorting in a work table, but the user I'm supporting reports occasional problems where the query *does* sort in a tempdb worktable causing all sorts of havoc.

I was trying to add a query plan option to make sure the query didn't use a tempdb worktable

This is probably something really simple, but I can't see it right now.

Thanks
Ben



Start Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:

select top 1 t.f1, t.f2, t.f3, d.f4
from #tmp t, mytable d
where t.f2=d.f2 and t.f3=d.f3
order by t.f5, t.f1, t.f2, t.f3
/* Tell query optimizer to first scan clustered
** index cidx on tmp table #tmp,
** then join the result to the index nc_idx on mytable
*/
plan
"( nl_join ( i_scan cidx table(t #tmp) ) ( i_scan nc_idx table(d mytable) )  )"
[+][-]08.29.2008 at 04:54PM PDT, ID: 22349932

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Sybase Database
Tags: sybase, ASE, 12.5.x
Sign Up Now!
Solution Provided By: grant300
Participating Experts: 1
Solution Grade: A
 
 
[+][-]09.02.2008 at 09:28AM PDT, ID: 22368863

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.02.2008 at 12:47PM PDT, ID: 22370886

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.02.2008 at 12:53PM PDT, ID: 22370945

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628