Hi.
I have a question regarding hints in derby.
I'm trying to run a simple query such as:
select col from tab where othercol=1;
with hints:
select col from tab
PROPERTIES index=<index name>
where othercol=1;
no matter how I put it I get syntax error on "PROPERTIES".
I try to run this command using eclipse/db visualizer.
Does anyone have an idea?
--------------------------------------------------------------------------------------------------------------------------------------------------------------
This email and any files transmitted with it are confidential and intended solely for the
use of the individual or entity to whom
they are addressed. If you have received this email in error please notify the originator
of the message.
Scanning of this message is performed by SurfControl E-mail Filter software in conjunction
with virus detection software.
|