Topic: The Mystery of Column Indexes
I am pretty green with this dba stuff. I get the gyst of what indexes do.. they are supposed to optimize performance on repetitive find queries. But I dont understand the SQL lingo behind them..
For example, I look at my db table and I see that my indexed columns show up, but under the column named "Null" they both mark "YES".. does this mean my indexes are Null?
There are other niggling quesitons like this, but more than anything, I am just curious
Why and when do you ues indexes?