Desktop Search Engines - my favourite

I have long been interested in Desktop Search products.
It's great for finding stuff on my PC without doing the Explorer find which can take a very long time.

These are the Desktop Search products I have tried and my take on them:

1. Copernic Desktop
  My favourite desktop search because it can index any type of text file. I have text files with .java, .sql, .jnl extensions and I can set up Copernic to index these files too
2. msn toolbar suite
  indexes only common files like microsoft excel, word, text files.
3. Google Desktop
  familiar interface but indexes only common files but not pdf
4. blinkx
  not stable, occasionally crashes on windows xp

Links

• Subscribe to this feed

10g explain plan output

found a new explain plan statement.

in addition to normal expected explain plan output like operation, access plan, cost and rows returned,
it also includes predicate information like:

Predicate Information (identified by operation id):
---------------------------------------------------


   2 - access("D"."OPERATOR_ID"="V"."FRANCHISE_ID" AND "D"."BILLING_NETWORK_OPERATOR_ID"="V"."NOP_ID")
     filter("D"."YEAR_MONTH_START_DATE">=TRUNC("V"."START_DATE") AND
     "D"."YEAR_MONTH_START_DATE"<=TRUNC(NVL("V"."END_DATE","D"."YEAR_MONTH_END_DATE")) AND
     NVL("D"."OP_VARIANCE_PERCENT","D"."BOP_VARIANCE_PERCENT")>=CASE WHEN
     ("V"."PREVIOUS_PERCENT"="V"."PERCENTAGE") THEN 0 WHEN ("V"."PREVIOUS_PERCENT"<"V"."PERCENTAGE") THEN
     "V"."PREVIOUS_PERCENT"+0.0000001 END AND "V"."PERCENTAGE">=NVL("D"."OP_VARIANCE_PERCENT","D"."BOP_VARIAN
     CE_PERCENT"))

The predicate information explains why a certain operation was taken at the step.

The script is simple:

SELECT plan_table_output
FROM table(dbms_xplan.display('plan_table', null,'SERIAL'));
-- parameters:
-- 1. plan TABLE name
-- 2. statement id -- Null will fetch the last explain plan
-- 3. level OF detail eg BASIC, SERIAL, TYPICAL, ALL

Links

• Subscribe to this feed