Solved

ASA6 force index usage

Posted on 2003-11-28
5
396 Views
Last Modified: 2012-05-04
I have Adaptive Server Anywhere version 6.
I have discovered in ISQL that, with the very same SQL statement, the engine doe not always choose the same index to retrieve the records. There must me some smart mechanism that tries to find out what the optimal index will be.
Sometimes I do not agree with the index chosen, so i would like to know I there is a way to force a specific index.
0
Comment
Question by:jvv
  • 2
5 Comments
 
LVL 6

Expert Comment

by:ChrisKing
ID: 9837813
On the assumption that ASA is similar to ASE ...

this is the format for ASE:
SELECT *
FROM yourtable (INDEX yourindexname)
WHERE ....
0
 

Author Comment

by:jvv
ID: 9838213
I tried it in ISQL.
The syntax is accepted, but the index clause is ignored.....:-((
0
 
LVL 6

Expert Comment

by:ChrisKing
ID: 9838257
sorry ... can't help with ASA
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 11535080
PAQed, with points refunded (250)

Computer101
E-E Admin
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

In this article, I will show you HOW TO: Install VMware Tools for Windows on a VMware Windows virtual machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, using the VMware Host Client. The virtual machine has Windows Server 2016 instal…
In this article, I will show you HOW TO: Perform a Physical to Virtual (P2V) Conversion the easy way from a computer backup (image).
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now