项目数据库索引

最新推荐文章于 2024-10-02 00:27:17 发布

anchang7456

最新推荐文章于 2024-10-02 00:27:17 发布

阅读量131

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/robbychan/p/3786512.html

版权

# book.xml 
CREATE        INDEX idx_nav_id ON book_info(nav_id);
CREATE UNIQUE INDEX uniq_id     ON book_info(id);

CREATE UNIQUE INDEX uniq_nav_id ON navigation(id);

CREATE        INDEX idx_lib_id ON book(lib_id);
CREATE        INDEX idx_lib_id ON book(book_info_id);

#borrowReturn.xml

CREATE UNIQUE INDEX uniq_user_rtx_borrow_num ON user(user_rtx(8),borrow_num);
CREATE        INDEX idx_lib_id               ON user(lib_id);

CREATE        INDEX idx_is_return            ON borrowed(is_return);

#reserve.xml

CREATE        INDEX idx_book_info_id         ON reserve(book_info_id);
CREATE        INDEX idx_lib_id               ON reserve(lib_id);
CREATE        INDEX idx_user_rtx             ON reserve(user_rtx(8));

转载于:https://www.cnblogs.com/robbychan/p/3786512.html