SAP SQL Anywhere
login
about
faq
questions
tags
users
badges
unanswered
ask a question
questions
tags
users
Questions Tagged With optimizer
active
newest
hottest
most voted
unanswered
1
vote
0
answers
8.7k
views
UNION ALL taking far longer than individual queries
22 Sep '15, 13:14
Justin Willey
7.6k
sa-16
optimizer
union-all
performance
2
votes
2
answers
1.8k
views
Worser Performance on 2nd call of same Statement
22 May '14, 03:21
Volker Barth
39.8k
performance
optimizer
0
votes
2
answers
3.5k
views
Does not work inline query optimization using UDF-DETERMINISTIC from "with" in SA 12
15 May '14, 09:52
Nick Elson S...
7.3k
optimizer
sa-12
error
3
votes
3
answers
4.6k
views
Sybase SA12, 16: Error query optimization with UDF
12 May '14, 10:51
Stalker
460
sa-12.0.1
sa-16
optimizer
error
3
votes
1
answer
2.2k
views
11.0.1.2405 Indexes not being used - Is this a known Problem?
15 Apr '14, 09:20
Mark Culp
24.8k
index
optimizer
sa-11
4
votes
1
answer
3.1k
views
Low Performance, because statistics aren't used with curent date, current timestamp
23 Apr '13, 11:36
Markus Dütting
536
performance
statistics
optimizer
0
votes
1
answer
2.2k
views
SQL Query that hangs
15 Apr '13, 09:48
Jeff Albion
10.8k
optimization
optimizer
long-running-query
0
votes
1
answer
1.6k
views
How the optimizer analyzes a query sybase?
29 Jan '13, 22:21
Graeme Perrow
9.6k
optimizer
1
vote
2
answers
2.1k
views
Peformance of IN vs. OR
01 Nov '12, 07:47
Gandalf
199
performance
optimizer
sql
1
vote
0
answers
1.6k
views
What does Index scan (all rows) mean?
30 Oct '12, 08:24
Martin
9.0k
optimizer
6
votes
7
answers
3.7k
views
query plan changes radically
29 Oct '12, 07:53
Volker Barth
39.8k
optimizer
long-running-query
2
votes
5
answers
3.6k
views
Optimizer Not Considering Usage of Index for Query Optimization
22 May '12, 06:28
Volker Barth
39.8k
performance
optimizer
sa-11
3
votes
3
answers
2.9k
views
Reusing of query plans
13 Mar '12, 10:03
Volker Barth
39.8k
optimizer
tuning
4
votes
1
answer
3.3k
views
Calibration best practices
06 Mar '12, 18:46
Mark Culp
24.8k
optimizer
calibration
4
votes
5
answers
5.1k
views
Intra-query parallelism
01 Feb '12, 08:19
Volker Barth
39.8k
optimizer
parallel
tuning
1
vote
2
answers
2.1k
views
Optimization in functions and procedures
11 Dec '11, 15:10
Volker Barth
39.8k
expression-evaluation
optimizer
stored-procedure
sa-10
2
votes
3
answers
2.5k
views
Force optimizer to choose indexscans
27 Oct '11, 14:49
Jeff Albion
10.8k
optimizer
6
votes
1
answer
5.1k
views
How is plan caching handled for multiple web service connections?
06 Oct '11, 09:38
Mark Culp
24.8k
performance
optimizer
1
vote
1
answer
1.7k
views
Has Create Statistics any effect for varchar columns?
26 Jul '11, 12:02
Glenn Paulley
10.8k
statistics
optimizer
0
votes
1
answer
1.7k
views
How can I help the optimizer estimating better?
25 Jul '11, 11:11
Mark Culp
24.8k
optimizer
0
votes
0
answers
1.4k
views
Why does this plan make sense?
22 Jul '11, 10:32
Martin
9.0k
optimizer
1
vote
1
answer
4.1k
views
View Pushed Predicate
15 Jul '11, 08:35
Volker Barth
39.8k
sa-10
optimizer
view
1
vote
1
answer
2.1k
views
Optimization_goal = 'Response-time'
09 Jun '11, 10:35
Volker Barth
39.8k
optimizer
sa-12
option
1
vote
1
answer
1.9k
views
Is a reverse index scan distinquished from an index scan?
23 May '11, 10:54
Mark Culp
24.8k
optimizer
0
votes
1
answer
1.6k
views
Optimizer using the first key word
20 May '11, 13:45
Breck Carter
32.5k
performance
optimizer
1
vote
1
answer
1.7k
views
Which statistics-level is used by Plan()?
10 Apr '11, 08:33
Glenn Paulley
10.8k
statistics
optimizer
select
0
votes
1
answer
2.1k
views
How to calibrate the IO read speed for the query optimizer?
14 Dec '10, 08:17
Martin
9.0k
performance
optimizer
27
questions tagged
optimizer
48
answers
Most
recently updated
questions
Related tags
sa-12
× 438
performance
× 273
sa-16
× 260
sa-11
× 143
stored-procedure
× 125
sa-10
× 119
error
× 93
sql
× 90
select
× 68
sa-12.0.1
× 63
index
× 31
view
× 31
optimizer
× 27
optimization
× 21
long-running-query
× 16
option
× 15
statistics
× 14
parallel
× 9
tuning
× 8
calibration
× 6
expression-evaluation
× 5
union-all
× 5
posts per page
15
30
50
First time here? Check out the
FAQ
!
×