Hi Robby,
We've added index-keys("idx-name") function. It returns all distinct keys.
You can try it with the latest dev build:
http://modis.ispras.ru/FTPContent/sedna/development/
Ivan Shcheklein,
Sedna Team
On Tue, Jan 15, 2013 at 7:07 PM, Robby Pelssers <[email protected]>wrote:
> 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:[email protected]]
> *Sent:* Tuesday, January 15, 2013 1:14 PM
> *To:* Олег Борисенко
> *Cc:* Robby Pelssers; [email protected]
> *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, Олег Борисенко <[email protected]> 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 <[email protected]>
> 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, 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
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/sedna-discussion****
>
> ** **
>
>
>
> ------------------------------------------------------------------------------
> Master Visual Studio, SharePoint, SQL, 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
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/sedna-discussion****
>
> ** **
>
------------------------------------------------------------------------------
Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013
and get the hardware for free! Learn more.
http://p.sf.net/sfu/sophos-d2d-feb
_______________________________________________
Sedna-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
