Sybase SQL Where statement

Computing.Net > Forums > Programming > Sybase SQL Where statement

Sybase SQL Where statement

Original Message

Name: Martin Hammer
Date: March 25, 2003 at 04:27:15 Pacific
Subject: Sybase SQL Where statement
OS: Win2k
CPU/Ram: P4/lots

Comment:

Hi,
Has anyone ever seen an expression in the WHERE clause of an SQL query of form
(T1.ROW_ID = '11111', 0.05)
What I'm after is what the 0.05 parameter means - I am guessing it's some kind of optimisation, but changing/removing it does not appear to make any difference.
The SQL is generated by a third party app and executed on Adaptive Sybase Anywhere 8.0.
Thanks for any help!
Martin

Report Offensive Message For Removal

Response Number 1

Name: SuperHumanIT
Date: March 27, 2003 at 14:23:44 Pacific

Reply: (edit)

It's forcing you to use an index on that particular column... basically it is an optimisation. however, sybase 8 ignores it is an optimisation for earlier versions.

Report Offensive Follow Up For Removal


oracle sql insert statement Need SQL query help. synchronization of sybase database ASP - Ms Access SQL Insert Problem Make data grid display SQL	SQL Select Statement PHP Question .NET ADO help PHP with Access Sql statement

Set db bound controls usi...

Delphi checking for empty...

Use following form to reply to current message:

Name: From My Computing.Net Settings E-Mail: From My Computing.Net Settings Subject: Sybase SQL Where statement

Comments:

  Homepage URL (*): 
Homepage Title (*): 
         Image URL:

Have you ever used OpenOffice?

Poll Finishes In 5 Days.
Discuss in The Lounge

Bootable cd and start SIW

western digital 80GB HD problem.

windows remote access vpn auth

can't get logged in on myspace, hel

Adware, Virus

All Posts Awaiting Replies