Repository for Databases course in Innopolis

Lab 4

main.py has functions for creating dbs(2 different dbs with the same columns), populating them with random data(2 different dbs with the same data), creating b-tree and hash indexes and analyzing

data.png is image with examples of added data.

before_indexing.png is image of output of "explain analyze" without indexes.

after_indexing.png is image of output of "explain analyze" with indexes(first is b-tree and second is hash).