Is it possible to have a look at what is there inside an index using SQL*Plus? If I have a table like this: Table A ———————— rowid | id name 123 | 1 A 124 | 4 G 125 …
Tag: database
How Do I aggregate Data By Day and Still Respect Timezone?
We are currently using a summary table that aggregates information for our users on an hourly basis in UTC time. The problem we are having is that this table is becoming too large and slowing our system down immensely. We have done all the tuning techniques recommended for PostgreSQL and we are still experiencing slowness. Our idea was to start
Synchronizing client-server databases
I’m looking for some general strategies for synchronizing data on a central server with client applications that are not always online. In my particular case, I have an android phone application with an sqlite database and a PHP web application with a MySQL database. Users will be able to add and edit information on the phone application and on the
How to show row numbers in PostgreSQL query?
I’d like to show the observation number for each record returned by a PostgreSQL query. I think in 8.4 windowing functions can perform this capability.
Make DataBase portable
I’m developing a local application with a DataBase in SQL Server 2008 and Visual Studio, C#, I created and connected to the Database in the application, but when I pass to work to another computer, copy the all solution files, the information that had been saved in it doesn’t exist, actually the entire Database doesn’t exist, so I ask: have
What is an unbounded query?
Is an unbounded query a query without a WHERE param = value statement? Apologies for the simplicity of this one. Answer An unbounded query is one where the search criteria is not particularly specific, and is thus likely to return a very large result set. A query without a WHERE clause would certainly fall into this category, but let’s consider
Oracle join query
There are three tables in my db: ITEM_MASTER, PRICE_MASTER and COMP_MASTER. ITEM_MASTER STORE_CODE ITEM_CODE ITEM_DESC 011 914004 desccc PRICE_MASTER STORE_CODE ITEM_CODE COMP_CODE …
Join one row to multiple rows in another table
I have a table to entities (lets call them people) and properties (one person can have an arbitrary number of properties). Ex: People Properties I would like to write an efficient select that would select people based on age and return all or some of their properties. It’s also acceptable to return one of the properties and total property count.
Simple check for SELECT query empty result
Can anyone point out how to check if a select query returns non empty result set? For example I have next query: Should I do something like next: to test if result set is not empty? Answer Use @@ROWCOUNT: According to SQL Server Books Online: Returns the number of rows affected by the last statement. If the number of rows
can we list all tables in msaccess database using sql?
Can we find all tables in the msaccess using sql . as we do in sqlserver in sqlite Answer Use MSysObjects