When i run the below query in syb15 (with syb 12.5.X backward compatibilty) environment it runs 45min where as the same in syb12.5.1 it takes only 7-10min.
But the main thing is stld_date(in the below query) does not covered in the index of that table. Also main_table is a huge table. So is it because of index for that column? . Can any one please provide ur suggestion to
change the query so i can get the response very fast like 7-10min but witout creating index we have to get the quciker result.
Even i tried the SET FORCEPLAN ON option but not worked out.
Last edited by Scott; 01-19-2010 at 05:13 PM..
Reason: When using code, please use code tags
I registered last week, received the emails and activated my account. It worked splendidly.
Today, I logged in, performed a search, then was prompted to login each time I moved to the next page in the search results.
I requested and received a new password but UNIX.com thanks me for logging... (0 Replies)
Hello.
Since Yesterday, I notice that after giving telnet IP or SSH IP - it takes long time to display login: , I mean earlier after entering Server name It used to immediately ask for login ID and then password. But, now it takes min of 2-3 minute to ask for password.
Where can I check,... (12 Replies)
I would like to use the result of a query in another query. How do I redirect/add the output to another variable?
$result = odbc_exec($connect, $query);
while ($row = odbc_fetch_array($result)) {
echo $row,"\n";
}
odbc_close($connect);
?>
This will output hostnames:
host1... (0 Replies)
When i run the below query in syb15 (with syb 12.5.X backward compatibilty) environment it runs 45min where as the same in syb12.5.1 it takes only 7-10min.
But the main thing is stld_date(in the below query) does not covered in the index of that table. Also main_table is a huge table. So is it... (0 Replies)
Hi,
I have a requirement as below which needs to be done viz UNIX shell script
(1) I have to connect to an Oracle database
(2) Exexute "SELECT field_status from table 1" query on one of the tables.
(3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
Below is my code. Every once in a while the select call takes as long as 150 seconds (discovered by printing time before and after this statement) while the timeout specified into it is only 1 second. Any clue why? I can't believe that select call which has been around for centuries can have a bug,... (15 Replies)
get email notification from from system when a process from XXXX user takes longer than 15 min run.Let me know the time estimation for the same.
hi ,any one please tell me , how to write a script to get email notification from system when a process from as mentioned above a xxxx user takes... (1 Reply)
I need to run sql script from shell script which takes the input from a file and contents of file will be like :
12345
34567
78657
and query will be like :
select seq_nbr from bus_event where event_nbr='12345';
select seq_nbr from bus_event where event_nbr='34567';
select seq_nbr... (1 Reply)
Hi,
I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database.
For instance:
USER CITY
--------- ----------
A CITY_A
B CITY_B
C ... (2 Replies)
Dear community,
please help with a query on Oracle. I'm using SQLPlus (but with SQLDeveloper is the same) to accamplish a sinple query like:
select count(*) from ARCHIT_D_TB where (TYP_ID=22 OR TYP_ID=23) and SUB_TM like '%SEP%' and CONS=1234This is a very simple query that works perfect until... (5 Replies)
Discussion started by: Lord Spectre
5 Replies
LEARN ABOUT DEBIAN
rdf::query::federate
RDF::Query::Federate(3pm) User Contributed Perl Documentation RDF::Query::Federate(3pm)NAME
RDF::Query::Federate - A subclass of RDF::Query for efficient federated query execution.
VERSION
This document describes RDF::Query::Federate version 2.908.
SYNOPSIS
my $service = RDF::Query::ServiceDescription->new( $url );
my $query = new RDF::Query::Federate ( $sparql );
$query->add_service( $service );
my $stream = $query->execute();
DESCRIPTION
...
METHODS
"new ( $query, \%options )"
"new ( $query, $base_uri, $languri, $lang )"
Returns a new RDF::Query::Federate object for the specified $query. The query language defaults to SPARQLP, but may be set
specifically by specifying either $languri or $lang, whose acceptable values are:
$lang: 'rdql', 'sparql11', or 'sparql'
$languri: 'http://www.w3.org/TR/rdf-sparql-query/', or 'http://jena.hpl.hp.com/2003/07/query/RDQL'
"add_service ( $service_description )"
Adds the service described by $service_description to the query's list of data sources.
"services"
"algebra_fixup ( $algebra, $bridge, $base_uri, $ns )"
Called in the fixup method of ::Algebra classes, returns either an optimized ::Algebra object ready for execution, or undef (in which
case it will be prepared for execution by the ::Algebra::* class itself.
AUTHOR
Gregory Todd Williams <gwilliams@cpan.org>
perl v5.14.2 2012-01-31 RDF::Query::Federate(3pm)