{"action":"created","issue":{"url":"https://api.github.com/repos/SiKirillo/sandbox/issues/3","repository_url":"https://api.github.com/repos/SiKirillo/sandbox","labels_url":"https://api.github.com/repos/SiKirillo/sandbox/issues/3/labels{/name}","comments_url":"https://api.github.com/repos/SiKirillo/sandbox/issues/3/comments","events_url":"https://api.github.com/repos/SiKirillo/sandbox/issues/3/events","html_url":"https://github.com/SiKirillo/sandbox/issues/3","id":374974414,"node_id":"MDU6SXNzdWUzNzQ5NzQ0MTQ=","number":3,"title":"SQL. Task 3. Indices","user":{"login":"qw4n7y","id":1701687,"node_id":"MDQ6VXNlcjE3MDE2ODc=","avatar_url":"https://avatars3.githubusercontent.com/u/1701687?v=4","gravatar_id":"","url":"https://api.github.com/users/qw4n7y","html_url":"https://github.com/qw4n7y","followers_url":"https://api.github.com/users/qw4n7y/followers","following_url":"https://api.github.com/users/qw4n7y/following{/other_user}","gists_url":"https://api.github.com/users/qw4n7y/gists{/gist_id}","starred_url":"https://api.github.com/users/qw4n7y/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/qw4n7y/subscriptions","organizations_url":"https://api.github.com/users/qw4n7y/orgs","repos_url":"https://api.github.com/users/qw4n7y/repos","events_url":"https://api.github.com/users/qw4n7y/events{/privacy}","received_events_url":"https://api.github.com/users/qw4n7y/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-10-29T11:37:07Z","updated_at":"2018-11-05T06:46:50Z","closed_at":null,"author_association":"COLLABORATOR","body":"1. Write in comments what are indices in database (no copy paste please). Reveal what data structures indices are based on. Reveal what is unique indices and composite indices.\r\n2. Learn what does `EXPLAIN` SQL command do. Create a table with a single column. Provide explanation of for two queries: first on the table with no indices and seconds for a table with index. Explain the difference in the query execution plans.\r\n3. Add required indices to the `fairytales` database's tables."},"comment":{"url":"https://api.github.com/repos/SiKirillo/sandbox/issues/comments/435770909","html_url":"https://github.com/SiKirillo/sandbox/issues/3#issuecomment-435770909","issue_url":"https://api.github.com/repos/SiKirillo/sandbox/issues/3","id":435770909,"node_id":"MDEyOklzc3VlQ29tbWVudDQzNTc3MDkwOQ==","user":{"login":"qw4n7y","id":1701687,"node_id":"MDQ6VXNlcjE3MDE2ODc=","avatar_url":"https://avatars3.githubusercontent.com/u/1701687?v=4","gravatar_id":"","url":"https://api.github.com/users/qw4n7y","html_url":"https://github.com/qw4n7y","followers_url":"https://api.github.com/users/qw4n7y/followers","following_url":"https://api.github.com/users/qw4n7y/following{/other_user}","gists_url":"https://api.github.com/users/qw4n7y/gists{/gist_id}","starred_url":"https://api.github.com/users/qw4n7y/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/qw4n7y/subscriptions","organizations_url":"https://api.github.com/users/qw4n7y/orgs","repos_url":"https://api.github.com/users/qw4n7y/repos","events_url":"https://api.github.com/users/qw4n7y/events{/privacy}","received_events_url":"https://api.github.com/users/qw4n7y/received_events","type":"User","site_admin":false},"created_at":"2018-11-05T06:46:50Z","updated_at":"2018-11-05T06:46:50Z","author_association":"COLLABORATOR","body":"Well-done!"}}
{"actor":{"display_login":"qw4n7y"}}