I have two question about how indicies affect queries:
1) If I have an index built for a given field FOO, and perform a query
with "like" such as "FOO LIKE 'ABC...' " does it benefit from the
index? Or is it only queries with equality conditions that benefit from
the index (eg: "FOO EQ 'ABC'
Hi Jeff,
1) If I have an index built for a given field FOO, and perform a query
with "like" such as "FOO LIKE 'ABC...' " does it benefit from the
index? Or is it only queries with equality conditions that benefit from
the index (eg: "FOO EQ 'ABC' ")?
An index can be used for a LIKE comparison
For UniData -
FOO LIKE "'ABC'..." I think so - because the first part is literal.
FOO LIKE "ABC..." I don't think so - because you aren't explicitly saying the
first part is a literal.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug
Unidata 7.2 on Redhat 6.2 64.
I got our Sysadmin to install ODBC on our UD server today so I can try
to use BCI to access data on SQL Server 2008 R2 directly.
After some experimenting we finally got the ODBC part going and can
connect to the right database from the command line.
He relinked the
I've checked our system and have no previous reports of this error.
Since our Linux versions are 32-bit and it seems you are running 64-bit Linux,
combined with the negative number, I would hazard a guess this is some 32-bit
on a 64-bit machine related problem.
Regards,
Dan
-Original Messa
That's some great info but I think the Stack Overflow people would
object to their site being used as a blog/wiki by a commercial entity.
I recommend putting nice articles like that on CodeProject.com, the
company website, or PickWiki.com.
T
> From: rkumar
> http://stackoverflow.com/questions/16
For anyone near the Denver area, I'll be doing a hands on demo/tutorial at the
upcoming CMUG meeting - June 11, 5:30pm for a 6pm start at Rocket's Denver
office.
http://www.eventbrite.com/event/6793013085
Cheers,
Dan
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailt
Dan:
Easy for me to say... Perhaps a video stream is possible from there...
--Bill
On Thu, May 23, 2013 at 2:25 PM, Daniel McGrath wrote:
> For anyone near the Denver area, I'll be doing a hands on demo/tutorial at
> the upcoming CMUG meeting - June 11, 5:30pm for a 6pm start at Rocket's
> De
The Colorado Multivalue Users Group usually has a GotoMeeting available;
check with Dan Schmitt for connection details.
On Thu, May 23, 2013 at 4:48 PM, William Brutzman wrote:
> Dan:
>
> Easy for me to say... Perhaps a video stream is possible from there...
>
> --Bill
>
>
> On Thu, May 23, 2013