Skip to content

Instantly share code, notes, and snippets.

@abarth500

abarth500/gist:1a96ec6d241826e20923

Created June 10, 2014 08:11
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save abarth500/1a96ec6d241826e20923 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save abarth500/1a96ec6d241826e20923 to your computer and use it in GitHub Desktop.
Download ZIP
[CS実験I] SELECT文の試行2
Raw
gistfile1.sql
--インデクスを強制的に使用しないで問い合わせをする方法
SELECT * FROM geotag IGNORE INDEX (PRIMARY) WHERE id = 7738073352;
--PRIMARYは主キーに自動で付けられるインデクスの名前
--この場合は検索に時間がかかります。
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment