Skip to content
This repository has been archived by the owner on Jan 28, 2021. It is now read-only.

sql.IndexLookup should be able to return the IDs of all indexes involved #333

Closed
erizocosmico opened this issue Aug 16, 2018 · 4 comments
Closed
Assignees
Labels
enhancement New feature or request

Comments

@erizocosmico
Copy link
Contributor

If we could return the IDs of all the indexes involved in an index lookup we might be able to present the user better information in describe queries. After assigning indexes we lose the ability to recall which index we used, so we only have the IndexLookups.

@ajnavarro
Copy link
Contributor

Could you provide an example of what do you want to accomplish with that change please?

@erizocosmico
Copy link
Contributor Author

DESCRIBE queries for squashed tables (and regular tables) in gitbase, for example, could output the IDs of the indexes being used, which is nice for debugging, since there's no way of telling if an index is being used or not right now other than manually debugging.

@ajnavarro
Copy link
Contributor

oh, I see. Per example, you want to print on the IndexableTable node something like:

IndexableTable
	Indexes:
		commit_author_name_idx
		commit_author_email_idx
[...]

@ajnavarro ajnavarro added the enhancement New feature or request label Aug 16, 2018
@erizocosmico
Copy link
Contributor Author

Exactly

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants