nteger |
> group_id | integer |
> meta_data_hash | character(40) |
Why are you using left join?
The where condition is going to force the row to exist.
klint.
+---+-+
: Klint Gore
ibution and query type would be heavily dependant
on random_page_cost? i.e. randomness of the data, size of the data
compared to physical memory.
klint.
+---+-+
: Klint Gore: "N
there can
be hundreds). You have to be prepared to use recursive functions and
make sure that a person doesnt appear anywhere higher in their family
tree.
klint.
+---+-+
: Klint Gore: "Non rhyming:
: EMail
es for delphi that I know of are vitavoom's
dbexpress (you should be able to find dbexppge.dll), zeos (you'll have
to grep the executable), ODBC using ADO or bde, Or dot net.
klint.
+---+-+
: Klint Gore: &quo
to order by both transaction_id, id.
klint.
+-------+-+
: Klint Gore: "Non rhyming:
: EMail : [EMAIL PROTECTED] : slang - the:
: Snail : A.B.R.I.: possibilities :
: Mail University of New England :
nd ea.incidentid = iid.incidentid
and ( recordtext like '%RED%' or recordtext like '%CORVETTE%' )
order by em.entrydate
klint.
+---+-+
: Klint Gore: "Non rhyming:
: EMail :
Anyone using power5 platform? something like an ibm eserver p5 520
running red hat linux.
(http://www-1.ibm.com/servers/eserver/pseries/hardware/entry/520.html)?
klint.
+---+-+
: Klint Gore: "Non rh
select * from v1 order by 2;
is run does it sort by 1 then resort by 2?
klint.
+---+-----+
: Klint Gore: "Non rhyming:
: EMail : [EMAIL PROTECTED] : slang - the:
: Snail : A.B.R.I.
n use the join to eliminate rows.
I would like a way to make this work better as well. One of my views is
32 joins of the same table (to get tree like data for reports).
klint.
+---+-+
: Klint Gore: "Non rhymin
ED_MOBILE_NUMBERS.mobile_num
klint.
+-------+-+
: Klint Gore: "Non rhyming:
: EMail : [EMAIL PROTECTED] : slang - the:
: Snail : A.B.R.I.: possibilities :
: Mail University of New England : are us
n upload (catch-all) (cost)
klint.
+-------+-+
: Klint Gore: "Non rhyming:
: EMail : [EMAIL PROTECTED] : slang - the:
: Snail : A.B.R.I.: possibilities :
: Mail University of New England : are useless&q
11 matches
Mail list logo
