Exactly... what I need is a function index-keys. It should resolve my
performance issue as well being it a workaround ;-)
Robby
From: Ivan Shcheklein [mailto:shchekl...@gmail.com]
Sent: Tuesday, January 15, 2013 1:14 PM
To: Олег Борисенко
Cc: Robby Pelssers; sedna-discussion@lists.sourceforge.net
Subject: Re: [Sedna-discussion] retrieving values from index
Hi Robby, Oleg,
First of all, doc("$indexes") is not internal. It's one of the documented and
officially supported meta-documents.
Then, it doesn't return keys set (that's what Robby asked, am I right?) AFAIR.
Finally, it should be really easy to implement index-keys("index-name")
function if we don't have one right now. Oleg, please check that we 100% don't
have such function already.
Ivan Shcheklein,
Sedna Team
On Mon, Jan 14, 2013 at 1:22 PM, Олег Борисенко
<a...@somestuff.ru<mailto:a...@somestuff.ru>> wrote:
Hello! It's very simple to do. Sedna has special internal command that shows
all the information about indexes without scanning them.
For example:
test> create index "testind" on doc("test")/mediawiki/namespaces/namespace by
@key as xs:string &
UPDATE is executed successfully
test> doc("$indexes") &
<indexes>
<index name="testind" backend="btree" as_type="xs:string"
on_path="child::element(mediawiki)/child::element(namespaces)/child::element(namespace)"
by_path="attribute::attribute(key)" object_name="test" object_type="document"/>
</indexes>
Best regards, Borisenko Oleg, Sedna team.
On Mon, Jan 7, 2013 at 6:17 PM, Robby Pelssers
<robby.pelss...@nxp.com<mailto:robby.pelss...@nxp.com>> wrote:
Hi all,
I was wondering if Sedna also has some functionality available to just read all
keys from an index. So far I could only find the index-scan() in the docs
which I already heavily use but this time I only want a set of keys.
My use case is that I have indexes per collection for all logical document
indentifiers. Ideally I'd want to use the index to retrieve the list of those
identifiers by only using the index. As Sedna has this info stored (in my
context), it would be great to get hold of it.
So is it possible in some way?
Robby
------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET<http://ASP.NET>, C# 2012, HTML5,
CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. SALE $99.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122412
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@lists.sourceforge.net<mailto:Sedna-discussion@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET<http://ASP.NET>, C# 2012, HTML5,
CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. SALE $99.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122412
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@lists.sourceforge.net<mailto:Sedna-discussion@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
------------------------------------------------------------------------------
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
