Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

ASA6 force index usage

Posted on 2003-11-28
5
Medium Priority
?
426 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
4 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to fix a SonicWall Gateway Anti-Virus firewall blocking automatic updates to apps like Windows, Adobe, Symantec, etc.
Do online retailers and e-commerce sites even need to bother with the season? Is it lucrative to update and prepare your site for Black Friday and Cyber Monday shoppers? We'll find out now.
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Loops Section Overview

824 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