Creating XML Indexes

Question

Creating XML Indexes

Steve Jones - SSC Editor

SSC Guru

Points: 736210
More actions
July 19, 2018 at 11:01 pm

#77275

Comments posted to this topic are about the item Creating XML Indexes

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Stewart "Arturius" Campbell SSC Guru Points: 72625 More actions · Answer 1

Now that is really interesting, thanks Steve.
Learned something new...

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

HappyGeek SSCoach Points: 18729 More actions · Answer 2

Got this wrong but learned something in the process, thanks Steve.

...

Shayn Thomas SSCertifiable Points: 5863 More actions · Answer 3

Very good question, Cheers Steve

---------------------------------------------------------------------------------------
The more you know, the more you know that you dont know

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 4

Thanks for the question Steve.
😎

The XML indices are very "interesting" when it comes to performance, let's say that the impact can be somewhat unexpected😉

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 5

Eirikur Eiriksson - Saturday, July 21, 2018 7:01 AM
Thanks for the question Steve.
😎
The XML indices are very "interesting" when it comes to performance, let's say that the impact can be somewhat unexpected😉

Heh... yes they do. They do it roughly the same way behind the scenes that people should do it to begin with. They remove the XML stuff and store the data in "index tables".

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

dstrickrott SSCommitted Points: 1951 More actions · Answer 6

Nice and interesting question. Learned something new. Thanks Steve.