Stack Overflow
Stack Overflow

Questions tagged [xmlindex]

11 questions
4
votes
1 answer

Oracle xmltype column indexing based on xml attribute

I am using structured storage type for xmltype column. I am trying to create an index on the attribute but somehow Oracle is not taking the index and doing a full table scan. I have checked the documentation at…
Kevin Parker
  • 55
  • 1
  • 3
2
votes
0 answers

MSSQL XML Index size

Can someone tell me if there is any sys table where I can find information about the size of XML indexes (both primary and secondary) in SQL Server? So far I've been using this script to check for the size of an index: SELECT t.name AS…
Sergiu
  • 432
  • 6
  • 18
2
votes
1 answer

Oracle xmltype column, create xmlindex with include below path

I need to create an xmlindex on and xmltype column, the system is Oracle 11g. The code I am using is: CREATE INDEX "TS"."XMLINDEX_NBXML" ON "TS"."NETBOTZ" V (NBXML) INDEXTYPE IS XDB.XMLINDEX PARAMETERS('PATH TABLE NETBOTZ_PATH_TABLE( TABLESPACE…
IFimbres
  • 23
  • 5
1
vote
1 answer

Dropping XMLIndex group and parameters

I have created structured part for the XMLIndex with this command. BEGIN DBMS_XMLINDEX.registerParameter( 'XXX', 'ADD_GROUP GROUP YYY XMLTable TABLE_NAME ''/entity/year'' COLUMNS year BINARY_DOUBLE PATH…
Yury Litvinov
  • 1,354
  • 2
  • 16
  • 24
1
vote
0 answers

Extract FULL DDL of XMLINDEX in Oracle

I want to extract DDL of XMLINDEX but when I run the below code I got incorrect or incomplete code. execute dbms_output.put_line(DBMS_METADATA.GET_DDL('INDEX','IDX_XML_AD','SCHEMAXX')); This is the output coming from the above command: CREATE…
swet
  • 207
  • 4
  • 15
1
vote
0 answers

Which XML index should I choose?

I have to search for a Postcode in my XML type column. I have created a primary XML index on my table. I am following this article to understand the concepts. My query looks like this select *some fields* from table_name…
SkoolCodeian
  • 127
  • 1
  • 14
1
vote
1 answer

Oracle XMLIndex - Making a Range Search

I'm storing my xml data in Oracle XMLType column, and I want to be able to make a range search over a number inside xml's. I suppose Oracle supports this kind of operation, but googling didn't help me. How should I create the XMLIndex and the range…
Feyyaz
  • 3,147
  • 4
  • 35
  • 50
1
vote
0 answers

With Oracle XML Tables do XQuery selects use XmlIndexes?

I am trying to retrieve keys and parent keys from some structured xml stored as binary xml in oracle. I have tried created unstructured index and also an index with a structured component. The structured component works fine when doing a SELECT…
Tom
  • 2,416
  • 3
  • 31
  • 38
0
votes
2 answers

SQL Query on DB2. contains function on XML column

My test table has two columns, one is message_xml of type XML and another is company_names of type VARCHAR. I would like to search for a word in each XML row and if the XML has it then export that XML. Here are 2 samples of xml stored in…
user3814614
  • 31
  • 1
  • 8